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?

David Fiorino

=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.

Stacy Weber

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