Good morning,
I am trying to create a formula to do with date ranges. If monday is 1st June and Friday is 5th June, how do I create a range that will give:
cell1: 1 Jun - 5 Jun
cell2: (a week later) - 8 Jun - 12 Jun
cell3: (2 weeks later) 15 Jun - 19 Jun
I want to have the mon-fri at the top of each column?
Any ideas??
Bookmarks