Date question
I'm trying to combine the word "Date:" with the TODAY() feature, so
that it looks like Date: 6/6/09. Can someone help?
One way is to put this in the cell
=TODAY()
and use
Format Cells Custom
with this in the Type:
"Date: "m/d/yy
This way, the cell is still a numeric date and it can be used in date
calculations.
|