Hi all
I've got a worksheet function using SUMPRODUCT that will count all the Mondays in any given month.
It works if I put it on a worksheet quite nicely. The formula is this:-
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(EOMONTH("05/01/2018",-1)+1&":"&EOMONTH("05/01/2018",0))))=2))
You can swap the...