Forum Discussion
Calculate 1st Sun, 2nd Sun, 3rd Sun, 4th Sun, and 5th Sun
Still not sure I understood correctly. If in C3 is 29th of Dec, for this given month December that will 5th Sunday. Formula to calculate
=(INT(DAY(C3)/7)+1) & CHOOSE(INT(DAY(C3)/7)+1,"st","nd","rd","th","th")& " Sunday"In each next block we add 7 to C3. For next block given month will be January, and formula like
=(INT(DAY(C3+7)/7)+1) & CHOOSE(INT(DAY(C3+7)/7)+1,"st","nd","rd","th","th")& " Sunday"etc.
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?