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.
Thanks for your response.
However, let me explain more clearly what I am trying the achieve.
Again, 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. I am looking for a way to place in cell C1 the date for any particular Sunday, and calculate 1st Sun, 2nd Sun, 3rd Sun, 4th Sun, and 5th Sun of the month, in cells C11, C23, C38, and C50 respectively.
I am looking for a formula to place in cells C11, C23, C38, and C50 that will yield either “1st Sunday”, “2nd Sunday”, “3rd Sunday”, “4th Sunday”, or “5th Sunday” (for that particular month), regardless of the date, placed in C1.
Thanks,
Richard
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. Please note that this year there are 29 days in February. Thus, beginning in cell U16 forward the date is an error. Can you provide a fix, so that going forward I will not have any errors on the template?
Thank You.
Richard
Do you need this updated for 2020? I noticed your dates are for 2019 which does not have 2/29.
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?
