View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
do you mean something like
=A1-DATE(2004,12,31)
and format as number there A1 stores your 2005 date

--
Regards
Frank Kabel
Frankfurt, Germany

help me wrote:
How do you change the date to a Number, example Jan 1, 2005 is the
1st day of the year and so on...