Rolling 4 weekly calendar

[Catsonheat]

Hi all, I am trying to make a sheet which will have a rolling 4 weekly calendar with week 1 in column A, week 2 in B, week 3 in C and 4 in D.

In each column will be the working days Monday - Friday and the dates. I am trying to make this a rolling calendar so for example column A would show Monday 4th February down to Friday 8th. Column B would therefore start Monday 11th etc. When the first week is over and the second week starts then the formula would update so the second week is now in Column A and the 4th week in column D is the new week which would have previously been unseen.

Hope this makes sense, apologise for the confusing description, essentially been trying to create this rolling calendar using NOW and WEEKNUM but not having much luck! Thanks in advance!

[KOKOSEK]

You can't put into B/C/D:

Please Login or Register  to view this content.

for some reason?
Or I miss something....

[Catsonheat]

Hi, if I put Today or Now function in A1 then it will not start A column with the first working day of the week. It would change every day. I would need to be able to see the whole week so A1 would always be the first working day of the week you are currently in and would not change until the start of the next week

[KOKOSEK]

Put into A1:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

return date of Monday in current week

[Root_]

The following simpler formula will return Monday of the current week:

=INT((TODAY()-2)/7)*7+2

[KOKOSEK]

That's nice and short. Thanks.

[Catsonheat]

Hi, thank you both for your responses. this looks like it is working! I'll test it over the next few days just to make sure it's working correctly in my spreadsheet but will mark the thread as resolved for now.

Thank you for the assistance, i will provide rep to both

[KOKOSEK]

You welcome.
Thanks for rep in advance.