Hello
I need to know how many days in month and year excluding Sundays.
Month is formatted as mmm-yy
Example Jan-23 has 31 days and has 5 sundays so the result should be 26
Hello
I need to know how many days in month and year excluding Sundays.
Month is formatted as mmm-yy
Example Jan-23 has 31 days and has 5 sundays so the result should be 26
Try
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1& ":" &A2)),2)<7))
A1=01/01/2023
A2=31/01/2023
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Another option:
if A1 contains the first day of the month: (format does not matter), please try:Formula:Please Login or Register to view this content.
Last edited by HansDouwe; 01-07-2023 at 05:53 AM.
Or with ANY date in the month in question:
=NETWORKDAYS.INTL(A1,EOMONTH(A1,0),"1111110")
Edit: I was away doing other stuff and forgot to refresh. This is identical to HD's... in BOTH cases it does NOT have to be the 1st of the month
Last edited by Glenn Kennedy; 01-07-2023 at 06:10 AM.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
if A1 is NOT the first of the month our formula counts too little days!in BOTH cases it does NOT have to be the 1st of the month
LoL. Not enough coffee (no coffee...) today!! You're right.
I see your problem has been solved. I'm curious how.
Have you benefited from any of our contributions? Should that be so, Glad to have helped.
Please consider adding reputation to all helpers, who you think they deserved because of the help provided.
If you want to, please click *Add reputation at the bottom left of their answers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks