Formula to Obtain Number of Total Workings Days in a Month Based on a Single Date

[clericalguy]

Hi

I am trying to obtain the number of workings days in a month based on any date.

For instance, date is 05/02/2024 = 19 workings days.

Thanks.

 

[Kerryx]

Book1
	B	C
2	05/02/2024	19
Sheet1

Cell Formulas
Range	Formula
C2	C2	=NETWORKDAYS(B2,EOMONTH(B2,0))

 

[clericalguy]

Book1
	B	C
2	05/02/2024	19
Sheet1

Cell Formulas
Range	Formula
C2	C2	=NETWORKDAYS(B2,EOMONTH(B2,0))

Thanks, but I made a mistake.

I meant total number of working days in the month to be extracted from any given date. So, if I have the date 05/02/2024, the total number of working days in February 2024 is 21 days.

 

[Kerryx]

Book1
	B	C
2	05/02/2024	21
Sheet1

Cell Formulas
Range	Formula
C2	C2	=NETWORKDAYS(EOMONTH(B2,-1)+1,EOMONTH(B2,0))

 

[clericalguy]

Book1
	B	C
2	05/02/2024	21
Sheet1

Cell Formulas
Range	Formula
C2	C2	=NETWORKDAYS(EOMONTH(B2,-1)+1,EOMONTH(B2,0))

This is perfect! Thank you!

 

[Peter_SSs]

This is perfect! Thank you!

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.