DRSteele
Well-known Member
- Joined
- Mar 31, 2015
- Messages
- 2,640
- Office Version
- 365
- Platform
- Windows
Can someone please help me?
I would like to enter a week number and have a formula report the date of the xth Monday or the day if it's a stub week. The stub week days should be week 1 and then the next Monday should be week 2.
I assembled this ugly formula, but I know there must be a better way.
I would like to enter a week number and have a formula report the date of the xth Monday or the day if it's a stub week. The stub week days should be week 1 and then the next Monday should be week 2.
I assembled this ugly formula, but I know there must be a better way.
Cell Formulas | ||
---|---|---|
Range | Formula | |
C4:F10 | C4 | =IF(OR(WEEKDAY(DATE(C$3,1,1),2)=1,$B4=1),DATE(C$3,1,1)+7*($B4-1),(DATE(C$3,1,1)+MOD(8-WEEKDAY(DATE(C$3,1,1),2),7))+7*($B4-2)) |