Column headder by week, month and must be a Monday most the time..

Hello,

I am trying to create a header row that incremented by week for the month, whenever possible a Monday. When a new month starts and it is not a Monday I want to have it there but the following row will be the next Monday. I hope that makes sense.
It would look like this”

9-Oct-17 16-Oct-17 23-Oct-17 30-Oct-17 1-Nov-17 6-Nov-17 13-Nov-17 20-Nov-17 27-Nov-17 1-Dec-17 4-Dec-17


So far I have this, which is anything but elegant:

Please Login or Register  to view this content.

*assumes that A2 has the start date

This gives me the week by month but does not “reset” to the Monday after the first of a month:

9-Oct-17 16-Oct-17 23-Oct-17 30-Oct-17 1-Nov-17 8-Nov-17 15-Nov-17 22-Nov-17 29-Nov-17 1-Dec-17 8-Dec-17

Can someone please help me solve this?

Thanks!

Try this ...

=IF(MONTH(WORKDAY.INTL(A2,1,"0111111"))=MONTH(A2),WORKDAY.INTL(A2,1,"0111111"),EOMONTH(A2,0)+1)

You have no idea how long I have worked on that.

This is perfect. Thanks!