Hi Bob -

The business I am does not cater to holidays. They are considered business
days as well. Would I just take out the ",holidays, 0))" portion of the
equation. This seems to be way over my head as I am not that familiar wtih
formulas.

"Bob Phillips" wrote:

This caters for holidays as well

=start_date+SIGN(B1)*SMALL(IF((WEEKDAY(start_date+ SIGN(days)*(ROW(INDIRECT("
1:"&ABS(days)*10))))={1,2,3})*
ISNA(MATCH(start_date+SIGN(days)*(ROW(INDIRECT("1: "&ABS(days)*10))),holidays
,0)),ROW(INDIRECT("1:"&ABS(days)*10))),ABS(days))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Kelly" wrote in message
...
Hello -

I have employees that have different number of business days they work. I
need to be able to calculate when the employee has utilized a specific
number
of business days specific to the days of the week they work and the number
of
days per week work. For example, if I have an employee that works 3
business
days per week (Specifically M, W, and F), and I need to know the date this
employee worked a total of 30 business days, is there a way to calcuate
this
date (which should be 6/9/06 if we use a start date of 4/3/06.