I tried to put 'january 1, 2005 into cell A1 and then entered =day(a1) into a
different cell but someting is wrong. the cell says #value now. where did I
go wrong..

"Don Guillett" wrote:

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