Find the Months that have 5 Fridays in them

[Stephen_IV]

I would like to be able to put the year in A1 and have in column B the months that have 5 Fridays in them. For instance if I put 2010 in A1, I would like in Column B January, April, July,October, December to appear. Any help would be appreciated if I put 2005 in A1 then I would like April, July, September, December. Thanks in advance Stephen.

 

[barry houdini]

You can probably simplify this somewhere but try this formula in B1

=IF(ROWS(B$1:B1)>4+(WEEKDAY(DATE(A$1,1,2))>6-(DAY(DATE(A$1,2,29))=29)),"",TEXT(SMALL(IF(DAY(DATE(A$1,ROW(INDIRECT("1:12")),35))< WEEKDAY(DATE(A$1,ROW(INDIRECT("1:12")),-5)),ROW(INDIRECT("1:12"))),ROWS(B$1:B1))*29,"mmmm"))
<?XML:NAMESPACE PREFIX = WEEKDAY(DATE(A$1,ROW(INDIRECT("1 /><WEEKDAY(DATE(A$1,ROW(INDIRECT("1:12")),-5)),ROW(INDIRECT("1:12"))),ROWS(B$1:B1))*29,"mmmm"))< p>
confirmed with CTRL+SHIFT+ENTER and copied down to B5
</WEEKDAY(DATE(A$1,ROW(INDIRECT("1:12")),-5)),ROW(INDIRECT("1:12"))),ROWS(B$1:B1))*29,"mmmm"))<>

 

[Stephen_IV]

jonmo1 thanks for your formula, barry houdini it works perfectly thank you so much. I appreciate all of posts. Thanks again.

 

[texasalynn]

you can't go wrong with Barry's work!!!!

and for the rest of you - you must not be busy. LOL but great work