AutoFill
 

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

AutoFill
 

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=514529