date format

[Chris Lane]

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?

 

[Dave Peterson]

="Today's date is "&text(today(),"mm/dd/yyyy")

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?

 

[Guest]

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]

Excellent, thanks Dave and bpeltzer

="Today's date is "&text(today(),"mm/dd/yyyy")