Count and show the months that have Friday the 13th in a given year.

[Stephen_IV]

This is an office thing especially that Halloween is coming up. I have been trying to figure this one out. The post below Barry Houdini had a great formula to count and show the months that have a 5 week friday. I would like to do the same for Friday the 13th but cannot figure it out. Can some one help!

http://www.mrexcel.com/forum/showthread.php?t=431025

Thanks in advance Stephen!

 

[jasonb75]

Not up to Barry's standard, but it works.

Where B1 contains the year of interest.

=IFERROR(TEXT(SMALL(IF(WEEKDAY(DATE(B1,{1,2,3,4,5,6,7,8,9,10,11,12},13))=6,DATE(B1,{1,2,3,4,5,6,7,8,9,10,11,12},13)),ROWS(B$1:B1)),"MMMM"),"")

Fill down 12 rows to get your list of months with friday 13th, then for the count of those months, either count the non empty cells, or use something like

=SUM(--(WEEKDAY(DATE(B1,{1,2,3,4,5,6,7,8,9,10,11,12},13))=6))

 

[Stephen_IV]

jasonb75,

Thank you so much. Works Great and is exactly what I wanted! Thank you again!