Thanks, now how can I change the date

"Don Guillett" wrote:

is this what you want?
=TODAY()-DATE(YEAR(TODAY()),1,1)

--
Don Guillett
SalesAid Software

"help me" wrote in message
...
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...