4 Week Microsoft Excell Spreadsheet Calendar Template

Question

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 have all cells with dates, update automatically. Can anyone help me with that? Thanks!

Richard

sergeibaklan · Answer

Richard_James&nbsp;
For next date, e.g. for F1, you may use
=C1+1
Date of week (D1)
=F1
and apply dddd format.
For next week (C12) it's =C1+7
&nbsp;

richard_james · Answer

SergeiBaklan&nbsp;&nbsp;There's 31 days in a month, or 28 days in a month. How will the above formula return an accurate date month to month, year to year?&nbsp;Thanks,Richard

sergeibaklan · Answer

Richard_James&nbsp;
It could be like
=IF( MONTH(C1+1)=MONTH(C1), C1+1, "")
&nbsp;

richard_james · Answer

Richard_James&nbsp;&nbsp;Because it's a date format. Right?Thanks again!!

sergeibaklan · Answer

Richard_James&nbsp;
Not sure I catch. Format is separate, for the dates you have "dd-mmm" and for the days of week "dddd".
If you put same date in these cells, it'll be like "21-Nov" and "Tuesday" accordingly.
&nbsp;
With formula you take previous date (e.g. in C1), check if next to it date is in the same month, if so return it, otherwise empty string.
&nbsp;
Please check in attached file, I did that for the cells D1 and F1.

Forum Discussion

4 Week Microsoft Excell Spreadsheet Calendar Template

5 Replies

Resources