AutoFill

[autofill]

I am using autofill to fill in weekdays, but i want it to exclude holidays.
is this possible?

[daddylonglegs]

If you have your start date in A1 then in A2 you can use the formula

=WORKDAY(A1,1,holidays) and copy down column, where holidays is a range of cells containing your holiday dates

note: WORKDAY is part of Analysis ToolPak add-in