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...
You'd have to add a test in the conditional formatting rules to check if the year is 1900, and adjust them accordingly.