Forum Discussion

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Mar 31, 2025

Re: Formula

=WORKDAY(start_date, n)

start_date is the starting date (e.g., a cell reference like A1).

n is the number of working days you want to add (excluding weekends).

 

If you also want to exclude holidays, you can add a range that lists the holiday dates. For example, if your holiday list is in C1:C5, the formula would look like this:

=WORKDAY(A1, 1, C1:C5)

This will skip weekends and the dates listed in the holiday range.

 

No RepliesBe the first to reply

Resources