Dates and times are just specially formatted numbers, so you have to tell
Excel how to format the number returned by the Now() function. Ex: ="Today
is " & TEXT(TODAY(),"Mmm dd")

--Bruce


"Chris Lane" wrote:

Hi
I need to insert a date into header, something like

="Today's date is "&Now()

However, the formula returns only the date number - I cannot figure out how
to return the date?

Can anyone assist me, please?