Monthly task list

[PierremontQuaker03]

Hi, I downloaded this template, and am wanting to change the date to the current month and beyond (see calendar tab) - I cannot get the dates to work, any ideas? Thanks

 

[herofox]

Hello -Try This

 

[PierremontQuaker03]

Hello -Try This

Thank you is it possible you can correct cell A1? - I am wanting to create a monthly calendar from February 2026 onwards

 

[MikeVol]

Insert in cell B2 (worksheet Calendar) next formula:

=DATE(P6,MATCH(P8,{"January","February","March","April","May","June","July","August","September","October","November","December"},0),1)

 

[AliGW]

In B2:

=DATE(P6,MONTH(DATEVALUE(P8&" 1")),1)

or:

=DATE(P6,MONTH(P8&0),1)

 

[herofox]

ok

PierremontQuaker03​

Thanks

 

[AliGW]

@herofox

You don't need that lookup list - see my post above yours.