Related:
- Help require to find correct Formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 4, 2011 at 07:10 AM
Oct 4, 2011 at 07:10 AM
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
networkdays formula would can give you days passed between two days by taking into account the holidays
Oct 4, 2011 at 07:35 AM
22-Sep-11, B column - 6 (working days), Now there is no other date column, hence as per your suggestion i need to insert one more column C=A2+B2, results 28-Sep-11. However actual answer should be 29-Sep-11 as Sunday needs to be excluded. In D Column if networkdays formula inserted then in holiday list 25-Sep-2011 is Sunday, but the formula is resulting into 5, whereas as per today answer should be 4.
Kindly provide the details that how the formula needs to be used so that i can get the correct answer. Pls help on urgent basis.
Oct 4, 2011 at 07:38 AM
Please help to get the correct answer .
Oct 4, 2011 at 07:54 AM
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....
Oct 4, 2011 at 07:56 AM
Oct 7, 2011 at 03:33 PM
A1: 22-Sep-11
B1= 5 (NOT 6 )
C1= WORKDAY(A1,B1,HOLIDAYS) : 29-Sep-11
D1 = =NETWORKDAYS(WORKDAY(A1,B1,HOLIDAYS),TODAY(),HOLIDAYS)