First off Hello to all here,
Secondly, I searched the forum for a match to my question but found none so here it is:

I am trying to use the DAY function to create a bill paying calendar but no matter what date code I put in I get one of the 31 days of January 1900. For example I use the following specific DAY function:

=DAY(40000)

The result in the cell:

6-Jan-1900

No matter what date code I enter into the function, the month and year will always be January, 1900. I am following the help section of Excel to the letter. What is wrong?
Thanks
Lou

The version of excel is 2002 (10.6866.6867) SP3