No of days in a Month excluding Sundays

[grcshekar]

Dear Experts

May I request the formula for calculating number of days in a month mmm-yy excluding sundays please. I mean for March result is 26 i.e. 31 - 5 sundays

[AliGW]

This, maybe?

=NETWORKDAYS.INTL(EOMONTH(TODAY(),-1)+1,EOMONTH(TODAY(),0),11)

or, with your lookup date in A1:

=NETWORKDAYS.INTL(EOMONTH(A1,-1)+1,EOMONTH(TA1,0),11)

[grcshekar]

It is returning output as #NAME?
The format of A1 is mmm-yy

[AliGW]

Ah, sorry - I didn't realise that you have such an old version. The function isn't available to you - sorry. Unfortunately, the NETWORKDAYS function does not have the weekend argument.

[grcshekar]

If that is not possible, is there way to find number of Sundays

[AliGW]

Probably, but I can't help. Sorry! Someone will know - just be patient.

[grcshekar]

I found this with google help but it returns 4 where as no of sundays is 5 in mar

=IF(DAY(DATE(YEAR(B1),MONTH(B1),1)+6-WEEKDAY(DATE(YEAR(B2),MONTH(B1),1),3))+28>DAY(EOMONTH(B1,0)),4,5)

[BMV]

Please Login or Register  to view this content.

[grcshekar]

Please Login or Register  to view this content.

What is this for a:a My data is only Mar-20 in Cell B1

[BMV]

try but change b4 to your b1 :-)

and also

Please Login or Register  to view this content.

[grcshekar]

try but change b4 to your b1 :-)

and also

Please Login or Register  to view this content.

Thank you, it returned 26 excluding sundays in given month. checked for Feb as well Works fine. Grateful to you