date format

C

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?
 
D

Dave Peterson

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



Chris said:
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?
Click to expand...
 
B

bpeltzer

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
 
Top