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.
Richard, let me clarify. In C11 where is now "CPE STUDENT"
you'd like to put the date which is first Sunday of the month. You mean next after C11 Sunday, or first Sunday of the month (e.g. December) within which C11 date or something else? Perhaps you may put manually in your sample what it shall be for given C11 (and better to highlight such cells).
I am looking for a formula to place in the highlighted red cells C11, C23, C38, and C50 that will calculate from C1 whether each Sunday is a “1st Sunday”, “2nd Sunday”, “3rd Sunday”, “4th Sunday”, or “5th Sunday” (for that particular month), regardless of the date, placed in C1. Please see attachment.
Thank You.
Richard
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.
I want to know two things. [1.] Is it possible to have a box for editing comments as I have outlined with dotted lines and shaded in blue, Instead of seral cells? [2.] Is it possible to delete non-bolded names in rows C15-C24, and automatically have those cells move up, to look similar to i.e. F15-C24? Thank you.
Richard
Hi Richard,
If you mean such comment
it could be formatted through right click menu. But I'm on Windows, you are on Mac, that could be specific - better if you repeat your question as new conversation here. Mac people could know better.
Keep only bold text and compact in one list - afraid it could be automated only with VBA programming, but that's not my expertise. Again better to ask as separate question.