Hello,
I need a formula that picks up the date for Monday provided that you have a given month and year. The first date will be the 1st of January and in the event that this day falls on a day other than Monday, I still want the start of the following week to be Monday, so the first week of each year may have a different formula than all other weeks.
2013, January falls on a Tuesday
Cell E10: Week 1
Cell E11: 1/1/13
The following week will reflect the following date of 1/7/13; therefore the formula +7 will not work, but for the remaining weeks, the date prior +7 will work
Cell F10: Week 2
Cell F11: 1/7/13
Cell G10: Week 3
Cell G11: 1/14/13
etc......
I hope I have explained this thoroughly. Thank you in advance.
Bookmarks