Forum Discussion
Solved
Date Error in Feb 2020
I am using Microsoft Excell on a Mac computer. I have created the attached 4 Week Microsoft Excell Spreadsheet Calendar Template, which includes calendar dates. I use the calendar repetitively as a t...
Richard_James , glad to help
Richard_James , it looks like duplicating of https://techcommunity.microsoft.com/t5/excel/calculate-1st-sun-2nd-sun-3rd-sun-4th-sun-and-5th-sun/m-p/1033206
Richard, there is no attachment
Sorry, but I didn't catch what is an error - dates are calculated correctly.
There are 29 days in February 2020 (not 28 Days). The 29th of Feb. should fall on Saturday, and the 1st of Mar. should fall on Sunday. In other words, there is an extra day in February 2020In other words there is an extra day in February 2020.
Let take your template and start it from Sun, 17 Feb
That gives correct calculation for 29 Feb and 01 Mar