Can the month be insterted and updated automatically?

Posted by Anthos on December 09, 2001 10:27 PM

I want to write on top of a report "Report of January - November 2001". Is there a way to update the November into December automatically and so on???

Thanks

Posted by anno on December 09, 2001 11:04 PM

if you put ="Report of January - " in cell A1 and =TODAY() in cell B2, with B2 custom formatted as "mmmm yyyy" it would change the final month automatically. you might have to fiddle with alignment and cell widths to make it look right - like i said, not very elegant.

Posted by anno on December 09, 2001 11:07 PM

sorry, getting tired - cell ref in last post should be B1 not B2 (nt)

Posted by Anthos on December 10, 2001 12:32 AM

Thanks man/mate/lad/dude depending from which country you're from!! (-:

Thanks again

Anthos

Posted by Ampleford on December 10, 2001 3:54 AM

Try the following:-

CONCATENATE("Report of January - ",text(now(),"mmmm yy"))

That makes it all text......