Forum Discussion
Issue with the s/n for 2/29/1900 when using EOM function
When using the EOM function for February 1900, Excel is using a serial number for 2/29/1900 of 59 not 60. I am aware the 1900 was not a leap year, but I understand that for compatibility Microsoft co...
What I find odd: If you pull up a calendar template and put the year at 1900, it gives you a Feb 29, 1900. But, if you put in a formula: =EOMONTH(DATE(1900,2,1),0),
It returns 2/28/00.
EOMONTH() checks in which month the date is according to Excel calendar, after that internally calculates end of month correctly taking into account leap years. Thus =EOMONTH("1900-02-28",0) and =EOMONTH("1900-02-29",0) both return Feb 28, 1900.
As for the template it depends on how it is done. For example, this template from Excel collection, if slightly modify, correctly returns first two months of 1900