date format
 

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?

date format
 

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



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?

--

Dave Peterson

date format
 

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?

date format
 

Excellent, thanks Dave and bpeltzer

"Dave Peterson" wrote in message
...
="Today's date is "&text(today(),"mm/dd/yyyy")



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?

--

Dave Peterson