Not exactly I mean Jan 1st is the first day of the year, so I want the cell
to have the number one in it. Jan 20, feb 1st is the 32nd day of the year, so
I would like the sell to have the number 32 in it.

"Frank Kabel" wrote:

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...