Thread: AutoFill
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
daddylonglegs
 
Posts: n/a
Default 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