Hi All,
I don't even know if this is even possible but here goes... This is based on an accommodation type of business for a mine site.
On Sheet1 I have named a few cells being:
StartMonth = 01/04/13
EndMonth = 30/04/13
Week1Start = 01/04/13
Week1End = 07/04/13
Week2Start = 08/04/13
Week2End...