Solved: Number of weeks in month

[Ironeshoe]

Hi, please help if possible.

I need the number of weeks in a month at any goven date of the month.

I have the formula to gain weeks in month using:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&EOMONTH(A1,0))),2)=1))

However if i am for example typing 12-jan-2021 the weeks change to 3 as opposed to 5 which would be the answer if i had input 01 jan 2021 ( for this example i am counting Fridays)

Is there anyway to do this?

 

[bosco_yip]

Based on your formula, just changed to >>

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(EOMONTH(A1,-1)+1&":"&EOMONTH(A1,0))),2)=1))

Regards

 

[Ironeshoe]

Based on your formula, just changed to >>

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(EOMONTH(A1,-1)+1&":"&EOMONTH(A1,0))),2)=1))

Regards

Brilliant thank you so much