wildturkey
Board Regular
- Joined
- Feb 21, 2006
- Messages
- 189
- Office Version
- 365
- Platform
- Windows
Have tried, have failed...
Cell F1 has todays date in it, Cells E1 to B1 should have the preceeding four days but if its a weekend the days are skipped. Ive then formatted to show the day only eg
Tue Wed Thur Fri Mon
Wed Thur Fri Mon Tue
Thur Fri Mon Tue Wed etc etc
Currently have the worlds longest nested IF that still doesnt work
Cell F1 has todays date in it, Cells E1 to B1 should have the preceeding four days but if its a weekend the days are skipped. Ive then formatted to show the day only eg
Tue Wed Thur Fri Mon
Wed Thur Fri Mon Tue
Thur Fri Mon Tue Wed etc etc
Currently have the worlds longest nested IF that still doesnt work