Count number of days between two date where off days are Friday,Sat & Only Friday

Hi All
I am new here and required an assistance in following 2 queries

As i am making process TAT(Turn Around Time) which required following information

In Excel 2007

1-Count number of days between two dates where working days are (Sun to Thursday). So required to exclude (Friday,Sat + Holidays)

A1-Start Date Mar/01/2014
B1-End Date Mar/31/2014
C1-No Of Days 22
D1-Days between two dates 21
E1 To E10-Holidays

2-Count number of days between two dates where working days are (Sat to Thursday). So required to exclude (Friday + Holidays)


A1-Start Date Mar/01/2014
B1-End Date Mar/31/2014
C1-No Of Days 27
D1-Days between two dates 26
E1 To E10-Holidays

Note : Any weekend (off days) dates listed in holidays should not effect the query


Appreciate your URGENT help

Please have a look at this:
http://www.excelforum.com/excel-form...ml#post3536846

Thanks for the prompt feedback.. let me check

Thanks Richard.. But this function is in Excel 2010 which is so easy... I am looking same assistance in Excel 2007

Originally Posted by chinraj

Please have a look at this:
http://www.excelforum.com/excel-form...ml#post3536846

Thanks Chinraj But i am sorry it seems not related with my requirements. I have alternate off days which is annoying me

I came up with following formulas

Exclude Fri,Sat+Holiday
=SUM(INT((WEEKDAY(B3-{1,2,3,4,5})+I3-B3)/7))-SUMPRODUCT(--(AF3:AF20>=B3),--(AF3:AF20<=I3))

Exclude Fri+Holiday
=SUM(INT((WEEKDAY(K3-{1,2,3,4,5,7})+M3-K3)/7))-SUMPRODUCT(--(AF3:AF20>=K3),--(AF3:AF20<=M3))

BUT
Only showing number of working days within two dates not between two dates
&
If you add dates of Fridays and Saturdays in Holiday field it also effects to result - "which shouldn't"



I believe i am so close

Superb ,, fantastic this is what i was looking for

Thanks a lot