Formular Workday Count
Hello, I've formula use Workday to count Due date = Start Date @row cell + option days.
fx Image below: Start Date is 04/24/25, then added 11 days = Resulted 05/09/25 as Due date.
Now, out of curiosity added days manually = Resulted 05/08/25 as Due date.
Some folks prefer manual countingπ. And I need to able to understand this difference result; To prevent potential misunderstanding that I add extra day.
Thank you,
Best Answer
-
Assuming your sheet is configured so that work days are Monday, Tuesday, Wednesday, Thursday, and Fridayβ¦
You start with Thursday 4/24/25.
Add 1 day and the due date is Friday 4/25 (1 work day after 4/24)
Add 1 more day (2 work days total) - Monday 4/28 as Sat 26 and Sun 27 are not working days.
Add 1 more day (3 work days total) - Tuesday 4/29
Add 1 more day (4 work days total) - Wednesday 4/30
Add 1 more day (5 work days total) - Thursday 5/1
Add 1 more day (6 work days total)- Friday 5/2
Add 1 more day (7 work days total) - Monday 5/5 (again skipping Sat and Sun)
Add 1 more day (8 work days total) - Tuesday 5/6
Add 1 more day (9 work days total)- Wednesday 5/7
Add 1 more day (10 work days total) - Thursday 5/8
Add 1 more day (11 work days total) - Friday 5/9
Answers
-
Assuming your sheet is configured so that work days are Monday, Tuesday, Wednesday, Thursday, and Fridayβ¦
You start with Thursday 4/24/25.
Add 1 day and the due date is Friday 4/25 (1 work day after 4/24)
Add 1 more day (2 work days total) - Monday 4/28 as Sat 26 and Sun 27 are not working days.
Add 1 more day (3 work days total) - Tuesday 4/29
Add 1 more day (4 work days total) - Wednesday 4/30
Add 1 more day (5 work days total) - Thursday 5/1
Add 1 more day (6 work days total)- Friday 5/2
Add 1 more day (7 work days total) - Monday 5/5 (again skipping Sat and Sun)
Add 1 more day (8 work days total) - Tuesday 5/6
Add 1 more day (9 work days total)- Wednesday 5/7
Add 1 more day (10 work days total) - Thursday 5/8
Add 1 more day (11 work days total) - Friday 5/9
-
Thank You!
-
Hi KPH,
Now, how do I configure sheet for specific Workday? I didn't know. This is very intriguing⦠when you get a chance. Best, Jinwon
"Assuming your sheet is configured so that work days are Monday, Tuesday, Wednesday, Thursday, and Fridayβ¦"
-
Glad I could help.
You can define your work days in the project settings, see:
Help Article Resources
Categories
Check out the Formula Handbook template!
