Work with dates

Find a date a number of working days away

How it works in Excel

• A2 is the start date.
• 10 is how many working days to move forward.
• Weekends are skipped.
• Use a negative number to count backward.
• Add a list of holidays as a third item.
• Format the cell as a date if you see a plain number.

The idea in general

It counts forward on the calendar but only steps on working days.

What I assumed

• The start date is in A2.

Check the result on your own data before relying on it.