LinkBack URL
About LinkBacks
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
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
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)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
It is returning output as #NAME?
The format of A1 is mmm-yy
Last edited by AliGW; 04-13-2020 at 11:16 AM. Reason: Please don't quote unnecessarily!
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.
If that is not possible, is there way to find number of Sundays
Probably, but I can't help. Sorry! Someone will know - just be patient.
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)
Please Login or Register to view this content.
Last edited by BMV; 04-13-2020 at 12:26 PM.
What is this for a:a My data is only Mar-20 in Cell B1Originally Posted by BMV
Please Login or Register to view this content.
try but change b4 to your b1 :-)
and also
Please Login or Register to view this content.
Last edited by BMV; 04-13-2020 at 12:41 PM.
Thank you, it returned 26 excluding sundays in given month. checked for Feb as wellWorks fine. Grateful to you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks