ExcelHeroThe WORKDAY function
Returns the date a number of working days later (or earlier).
In German Excel: ARBEITSTAG
How to write it
=WORKDAY(start_date, days, [holidays])- start_date
- The date to start from.
- days
- Working days forward, or negative for back.
- holidays
- Optional. Days off to skip.
💡 Perfect for deadlines like “in 5 working days”.
Try it
Testing has to be done 5 working days after it starts. What is the deadline?
A
B
C
D
1
Task
Start
End
Deadline
2
Design
6/2/25
6/13/25
3
Build
6/16/25
7/11/25
4
Test
7/14/25
7/25/25
5
6
Holidays
6/9/25
6/19/25
=WORKDAY(start, 5) skips the weekend for you.