Awesome! That's precisely what I was looking for, Matej. Kudos to you
and this whole maillist concept :).
Matej Cepl wrote:
Randomthots wrote:
=CONCATENATE("Today's Date: "; today())
One possibility: go into Format -> Cells and find the appropriate date
format. Then put your cursor into the format string box at the bottom
and add this to the front of it: "Today's Date: "
For example, if you put in the format code:
"Today's Date: "NNNNMMMM D, YYYY
You get
Today's Date: Wednesday, December 7, 2005
Other possibility is to use
=CONCATENATE("Today's Date: "; TEXT(today(),"XXX"))
And instead of XXX put the format of date you desire (see help for more).
Matej
