View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Consecutive date calculation involving holidays

On Thu, 12 Nov 2009 13:39:01 -0800, BMoran
wrote:

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!


If you look at HELP for the WORKDAY function, you will see how to use the
optional HOLIDAYS argument.
--ron