Hi All,
I am currently trying to design/design a worksheet for the following and am about to rip out my hair! I hope someone can shed some light on where I am going wrong or what would be the best way of doing this.
Main Layout
Cell A1 = Month Drop Down List
Cell A3 = Week Number (1,2,3,4)
Cell B3 = Month 1 Chosen Date (Monday or Friday)
Cell B4 = Month 2 Chosen Date (Opposite day from same week e.g. if B3 is Monday then B4 would be Friday)
Needing to have any changes to the Week Column needs to update to that week's Monday and Friday.
Monday Code (C1)
=$C$1+7-WEEKDAY($C$1+5)
Subsequent Mondays are entered as C1+7, C1+14, etc.
Friday Code (C2)
=$C$1+7-WEEKDAY($C$1+5
subsequent Fridays are entered as C2+7,C2+14, etc.
I hope the above information is clear and understandable, happy to supply any further information needed or a copy of the worksheet so far.
Anthony
Bookmarks