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

change the array {2,3,4,5,6} to the weekdays that you want to use as working
days.

It uses three named ranges

start_date - single cell, obvious
days - single cell, the working days to project forward
holidays, range, an array of holiday dates

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Rohin Bhatia" <Rohin wrote in message
...
HOW CAN I CALCULATE WORKDAYS IN EXCEL BY SETTING SATURDAY ALSO AS A
WORKING
DAY ??