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...
Moreover, all days in Jan-Feb 1900 are to be shifted to the right excluding Feb 29 to make calendar correct. Jan 01, 1900 is Monday, not Sunday. But that all depends which formulae do you use behind.