today()

[bern]

I wish to have a formula in a3 such as:

"Concatenate(a1,a2)" where a1 contains the text "today is" and a2
contain the function today().

Unfortunately, concatenate gives me: "today is37878", 37878 being the
serial number of the date. I have tried formatting each cell every
which way to get the date as it is shown in cell a2, but to no avail.
There also seems to be no function to return the serial number back to
a readable date.

any suggestions?

Thanks

 

[Earl Kiosterud]

Bern,

A couple ways to do that.

="Today is " & TEXT(TODAY(),"mm/dd/yy")

This results in text in the cell, so you can't refer to it in some other
formula to get the date. You'd probably just use TODAY in the other cell
anyway, and hope that the recalc didn't happen to occur right at midnight
where some fell before and some after. Are we getting really fastidious?

Or you can do it with:

=TODAY()

and use number formatting to put in the text. Format - Cells - Number -
Custom:

"Today is" mm/dd/yy
"Today is" mmm dd, yyyy etc.

Earl Kiosterud
mvpearl omitthisword at verizon period net

 

[Boxman]

This formula will do what you want but you will be limited in the output
format.

=CONCATENATE(A1,(MONTH(B1)&" / "&DAY(B1)&" / "&YEAR(B1)))