Formular Workday Count

JinwonK

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,

KPH

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