Possible to alert that date is not a weekday?
Stacy Weber
✭✭
I'm creating an event tracking sheet that includes all of the due dates for each event. The formulas auto-populate based on the event date. Is there a way to "flag" a date that falls on a weekend so it can be adjusted to a workday?
Answers
-
=IF(WEEKDAY(DATE@row) = 7, DATE@row + 1, IF(WEEKDAY(DATE@row) = 1, DATE@row + 2))
This will add one day to a Sunday or two days to Saturday to move them to the next Monday.
-
Thank you. How do I add this to the formula that is already in the column? For instance, this is the formula I currently have:
=[meeting start date]@row-15
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives