Date question

[M Thompson]

Hi

I'm trying to combine the word "Date:" with the TODAY() feature, so that it
looks like Date: 6/6/09. Can someone help?

Thanks and have...

 

[MyVeryOwnSelf]

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.

 

[M Thompson]

Good idea. Thanks!
--
OneFineDay

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.