Previous Topic Next Topic

Require Correct Formula in Excel

Closed
Annie - Oct 7, 2011 at 01:15 AM
 Annie - Oct 7, 2011 at 07:34 AM
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 3-Oct-2011. 3 will be the correct answer as i need to exclude Sunday.
Please help.
Networkdays formula will not do as it is excluding Saturday as well as Sunday. HOwever i only need to exclude Sunday.

Would appreciate if anyone could helpme out ASAP.

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 7, 2011 at 06:22 AM
a1 has entry 9/29/11
b1 has entry 10/3/11

you can format as you like

in empty cell type formula

=NETWORKDAYS(A1,B1)

you will get 3
0
Annie
Oct 7, 2011 at 07:34 AM
Dear Venkat,

In my case I have only data for issue received date i.e A1-9/29/11 and TAT for its closure of the particular issue is 6 working Days i.e B1- 6, Now i need to find out what is my closure date or the escalation column- which means how many days are in my hand to solve the issue. Kindly help on urgent basis. Thanks.
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response