Forum Discussion
Date Error in Feb 2020
Richard_James , glad to help
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.
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.
As you know, 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 template.
Question One: Once I get everything set up the way I want it, I would like to know how do I protect the format so that cell sizes and boarders cannot be changed but would allow my secretary to input data (names) into the cells?Question Two: Notice in cells A1 and A16 that they are grammatically incorrect, i.e., “4rd” and “1rd”. What do I need to do to the formulas in A1, A16, A31, and A46 to a sure that It will return the creamer correct grammatical statement, i.e., “1st”, “2nd”, “3rd”, “4th”, regardless where any particular week shows up?
Richard_James , glad to help
- Thanks everyone. I really appreciate it!!!
Riny_van_Eekelen , thank you, it looks I was not able to articulate that in direct way.
Richard_James Allow me to contribute to the discussion and, perhaps duplicate what SergeiBaklan tried to explain. When I download your file I notice that you have 16 Feb 2019 in cell C1. Try 16 Feb 2020 and the problem will be solved, I guess.
