View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Date command in Excel headers

So the value in the header is 2010 or is it 1/1/2010 formatted to show only
the year? If it is only the year then what date were you hoping for. What
formula did you want to use against the date?

--
HTH...

Jim Thomlinson


"Doug" wrote:

How do I enter a date command in a header that displays only the current year
and not the complete date?