Help require to find correct Formula
[Closed]
Report
annie

Annie 
Annie 
Related:
 Help require to find correct Formula
 If condition formula required ✓  Forum  Excel
 Excel Formula Help Required. ✓  Forum  Excel
 Spreadsheet formula  Articles
 Excel @ in formula ✓  Forum  Excel
 A considering that organisation requires communication today office automation is no longer limited to simply capturing handwrit  Articles
Please help to get the correct answer .
1Sep11 12Sep11 6(=networkdays(A2,B2,"Holidays")
In the Holiday List 1Sep11 & 9Sep11 is considered as Holiday. hence the answer shoul come 8 whereas I suppose it is excluding saturdays also.
And my concern is only to exclude sunday. I hope the things are things now. Pls help urgently....
A1: 22Sep11
B1= 5 (NOT 6 )
C1= WORKDAY(A1,B1,HOLIDAYS) : 29Sep11
D1 = =NETWORKDAYS(WORKDAY(A1,B1,HOLIDAYS),TODAY(),HOLIDAYS)
Pls explain on what basis B1 is being taken as 5 instead of 6. Actually the correct TATturnaround time to complete the particular issue is 6 working days.
Am not getting the answer. How to get the correct answer. Pls help...