Help require to find correct Formula

[Closed]
Report
-
 Annie -
Hello,

Received one issue on 22-Sep-11, the turnaround time to solve this issue is 6 working days therefore the Expected date of Closure is 29-Sep-11, excluding sunday-the non-working day. Would appreciate if you could please provide me the correct formula in MS Excel to find the escalation day as on today(3-Oct-2011). 3 will be the correct answer as i need to exclude Sunday.
Please help.




1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Workday formula should give you the date by taking into account the holidays

networkdays formula would can give you days passed between two days by taking into account the holidays
formula used by me as follows: =NETWORKDAYS(A2,C2,"Holidays")

Please help to get the correct answer .
A B C
1-Sep-11 12-Sep-11 6(=networkdays(A2,B2,"Holidays")

In the Holiday List 1-Sep-11 & 9-Sep-11 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....
In the above comment A column is 1-Sep-11, B column is 12-Sep-11 & result in C column is 6and formula used as (=networkdays(A2,B2,"Holidays")
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
This is how i see it

A1: 22-Sep-11
B1= 5 (NOT 6 )

C1= WORKDAY(A1,B1,HOLIDAYS) : 29-Sep-11
D1 = =NETWORKDAYS(WORKDAY(A1,B1,HOLIDAYS),TODAY(),HOLIDAYS)
Hi,
Pls explain on what basis B1 is being taken as 5 instead of 6. Actually the correct TAT-turnaround time to complete the particular issue is 6 working days.
Am not getting the answer. How to get the correct answer. Pls help...