View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CMIConnie
 
Posts: n/a
Default I need today's date returned as date format in formula

I have the following formula: =CONCATENATE("W ",TODAY()). It returns W
38771, but I need it to return W 02/23/06. Is this possible?
I have Excel 2000