=SUMPRODUCT(INT((end_date-WEEKDAY(start_date+1-{2;3;4;5;6;7})-start_date+8)/
7))-
SUMPRODUCT(ISNUMBER(MATCH(WEEKDAY(holidays),{2;3;4 ;5;6;7},0))*(holidays=sta
rt_date)*(holidays<=end_date))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Karthik" wrote in message
...
I am aware of the NETWORKDAYS function in EXCEL for TAT (Turn Around Time)
Calculations between days excluding weekends and holidays. However, I want
to
know if there is a way of doing the same calculation including Saturdays
only
since it is considered as a workday for my calculation purposes.

Is there any way this can be done with a formula available in Excel 2002?