Help need to calculate number of working days(Saturday - Thursday) between two dates month wise while considering holidays list

[Saiket007]

I have data as below:

Start Date

End Date

January-10

February-10

March-10

April-10

May-10

June-10

July-10

August-10

September-10

October-10

November-10

December-10

Holidays

8/1/2022

10/1/2022

30​

30​

30​

Tuesday, March 1, 2022​

5/3/2022

7/1/2022

28​

30​

30​

Sunday, February 6, 2022​

Wednesday, March 9, 2022​

Tuesday, May 3, 2022​

Sunday, July 3, 2022​

I need results as below (example showing number of working days in each month based on start and end date) (please also consider working days is Saturday to Thursday)

 

[jasonb75]

The dates and expected results in your data don't appear to match (2010 dates in row 1? number of days entered does not match the working days per month based on the start and end dates as described).

Hopefully this is what you need? Note that all of the dates used must be in a valid format for this, or any similar formula to work. Although I can not say this with 100% certainty, I am confident that the holiday dates shown are not entered in a valid format.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Start Date	End Date	January-22	February-22	March-22	April-22	May-22	June-22	July-22	August-22	September-22	October-22	November-22	December-22	Holidays
2	08/01/2022	10/01/2022								27	25	1			03/01/2022
3	05/03/2022	07/01/2022					24	26	0						02/06/2022
4															03/09/2022
5															05/03/2022
6															07/03/2022
Sheet1

Cell Formulas
Range	Formula
C2:N3	C2	=IF(AND(C$1<=$B2,EOMONTH(C$1,0)>=$A2),NETWORKDAYS.INTL(MEDIAN($A2,C$1,EOMONTH(C$1,0)),MEDIAN($B2,C$1,EOMONTH(C$1,0)),16,$O$2:$O$6),"")

 

[Saiket007]

Hello Jason, First of all thanks for your support on solving the issue.

But further I need see the month wise days split based on my start date and end date.

I need below type result when i will input start date and end date

Production Start Date

Production End Date

Jan-21

Feb-21

Mar-21

Apr-21

May-21

Jun-21

Jul-21

Aug-21

Sep-21

Oct-21

Nov-21

Dec-21

Jan-22

Feb-22

Mar-22

Apr-22

May-22

Jun-22

Jul-22

Aug-22

Sep-22

Oct-22

Nov-22

Dec-22

22-Dec-21​

6-Mar-22​

9

31

28

6

22-Dec-21​

8-Aug-22​

9

31

28

31

30

31

30

31

8

 

[jasonb75]

But further I need see the month wise days split based on my start date and end date.

That is what I've done. As I already said, your examples don't match what you have asked for. If the answer provided is not what you want then it is your question that is wrong, not the answer.

You're asking for the number of working days in the specified date range but the expected results that you have shown include all days, not just the working days specified.