Number of Sundays in a Month

Hello all, I need help!

I need to know the number of Sundays in a month... but the reference cell is the abbreviation of the month, e.g. Jan, not the first of the month. In other words, I need to know the Sundays for Jan not 1/1/2018.

I've been trying to edit this formula to no avail: =SUMPRODUCT(N(WEEKDAY(ROW(INDIRECT(A1&":"&EOMONTH(A1,0))))=1)) works but based on dd/mm/yyyy NOT the month abbreviation.

Please help! Thank you in advanced!

Can we assume that it is always for 2018?

So, if A1 in that formula is meant to contain a date, then you can achieve that by using this instead of A1 (twice):

=DATEVALUE("1 "&A1&" 2018")

or in America you may need to use:

=DATEVALUE(A1&" 1 2018")

where A1 now contains the 3 letter code for the month, e.g. "Jan".

Hope this helps.

Pete

Try this:

=SUMPRODUCT(N(TEXT(ROW(INDIRECT((A1&1)+0&":"&EOMONTH((A1&1)+0,0))),"ddd")="Sun"))

Try

=4+ISNUMBER(MATCH(1,WEEKDAY(--({29,30,31}&$A$1)),0))

Wow 63falcondude! Thank you a million! It works!!

Happy to help. Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.