View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BMoran BMoran is offline
external usenet poster
 
Posts: 4
Default Consecutive date calculation involving holidays

I know that you can figure out a date using the WORKDAY function, but how do
you figure out a date for just consecutive days.

I basically want to add days to an initial date while keeping a list of
holidays in mind.
A B
1 11/01/09

I want column B to add 50 days to column A while keeping track of the
holiday list. This is the formula I use for the Workdays:
=WORKDAY(A1,50,$J$1376:$J$1390)

Thanks!