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...
All you can do is cater for the wrong Feb 29 1900 date in your conditional format I'm afraid.
Or set your Excel file to use the 1904 date system. But since that isn't the default AND copying and pasting into other files (which are very likely set to the default 1900 date system) will cause your pasted dates to be off by 4 years, I do not recommend to do this.