I don't know about Frank or the others, but exactly what do you want?
Another cell with a date in it or the day of the current date???
Pls be VERY clear.

--
Don Guillett
SalesAid Software

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