Consecutive date calculation involving holidays

  • Thread starter Thread starter BMoran
  • Start date Start date
B

BMoran

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!
 
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!
Click to expand...

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