I am using autofill to fill in weekdays, but i want it to exclude holidays. is this possible?
A autofill Feb 20, 2006 #1 I am using autofill to fill in weekdays, but i want it to exclude holidays. is this possible?
D daddylonglegs Feb 20, 2006 #2 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
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
