# Consecutive date calculation involving holidays

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!

R

#### Ron Rosenfeld

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