Forum Discussion
Date Error in Feb 2020
- Jan 25, 2020
Richard_James , glad to help
Richard_James , glad to help
- Richard_JamesFeb 27, 2020Brass Contributor
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?