thesurfdoggie
New Member
- Joined
- Nov 19, 2020
- Messages
- 2
- Office Version
- 2013
- Platform
- Windows
I am using a formula to create due dates for a task. The formula is, =WORKDAY(E9,D10,M9:M17) where E9 is a date, D10 is a number of days and M9:M17 is a list of holidays.
When the WORKDAY formula output lands on a Saturday or Sunday, the output defaults to the following Monday. I need to have the output to default to the Friday before, not the Monday after. I tried using the WEEKDAY function to resolve, but since the WORKDAY already resulted in a Monday output, the WEEKDAY function doesn't do anything.
Thoughts??
When the WORKDAY formula output lands on a Saturday or Sunday, the output defaults to the following Monday. I need to have the output to default to the Friday before, not the Monday after. I tried using the WEEKDAY function to resolve, but since the WORKDAY already resulted in a Monday output, the WEEKDAY function doesn't do anything.
Thoughts??