How can the "NOW()" function be used in text.

[DWW1945]

I would like to have a current date in a sentence within a spreadsheet.

 

[Bob Phillips]

="Today's date is "&TEXT(TODAY(),"dd mmm yyyy")

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Max]

Try something like :

="The date / time is: "&TEXT(NOW(),"dd-mmm-yyyy h:mm AM/PM")