Thread: Date question
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
MyVeryOwnSelf[_2_] MyVeryOwnSelf[_2_] is offline
external usenet poster
 
Posts: 143
Default 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.