Even if you have a text format or an apostrophe ' before January 1, 2005,
=day(a1) will yield 1

--
Don Guillett
SalesAid Software

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