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.
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.