Forum Discussion
Formula
What formula within excel would be best to use when attempting to autofill dates without the weekends included
=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.