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
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
- It would be nice to start week one on Sunday, February 17, 2020. However, the reality is that Sunday we one is actually February 16, 2020. Therefore, I must start Sunday of Week 1 as
February 16, 2020. Furthermore, because there are 29 days in February of 2020 (instead of the usual 28 days) there must be something wrong with the formula. Please advise.- It would be nice to start week one on Sunday, February 17, 2020. However, the reality is that Sunday we one is actually February 16, 2020. Therefore, I must start Sunday of Week 1 as
February 16, 2020. Furthermore, because there are 29 days in February of 2020 (instead of the usual 28 days) there must be something wrong with the formula. Please advise.
- 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.