Challenge #241: Friday the 13th

A solution to last week's challenge can be found here. Source: https://en.wikipedia.org/wiki/Goaltender_mask

This Friday will be another Friday the 13th. Whether or not you consider yourself to be superstitious, odds are you're familiar with this dreaded calendar configuration.

But just how common are these occurrences? For this week's challenge, construct a workflow that provides a count of the number of Friday the 13ths for each year since 1900.

Bonus: Are there any years that don't have a Friday the 13th?

challenge_241_start_file.yxmd

challenge_241_solution.yxmd

Preparation

Advanced

Intermediate

Data Preparation

Transform

Accepted answers

All comments

Aaron_Harter

Spooky challenge!

Spoiler

challenge_241_AB Data_Aaron.yxmd

patrick_digan

Spoiler

And for the bonus, I think we can prove that there will always be a Friday the 13th. We can ignore January and February due to leap year weirdness, and just prove that regardless of what day March the 13th will fall on, there will be a friday the 13th at some point in March-December. Here are the months:

challenge_241_start_file.yxmd

dsmdavid

Spoiler

I always need to check the date formats (https://help.alteryx.com/current/designer/datetime-functions) should bookmark it...

david_241.yxmd

Blake

Nice quick one this week!

Spoiler

Video solution below

Spoiler

challenge_241_start_file_BH.yxmd

JennyMartin

Spoiler

Quick, fun challenge, meaning the associated video is also nice and short: https://www.youtube.com/watch?v=Tu587UuaMt0&list=PL18SpOXDj-KMUD4YwWC5vZaUsIa7drxNZ&index=45

AWC241.yxmd

AkimasaKajitani

My solution.

Spoiler

challenge_241_start_file_AK.yxmd

DeanWest

There's no escape...

Spoiler

challenge_241_solution-DeanWest.yxmd

AngelosPachis

Nice quick challenge for this week!

Spoiler

challenge_241_solved_AP.yxmd

philipmannering

Solution attached. 🙂

Spoiler

challenge_241_start_file.yxmd

RolandSchubert

Nice challenge.

Spoiler

challenge_241_solution_rsc.yxmd

Jonathan-Sherman

Challenge 241 is done!

Spoiler

challenge_241_JMS_solution.yxmd

balajilolla

Spoiler

Solution Attached

challenge_241_start_file.yxmd

DaisukeTsuchiya

Spoiler

challenge_241_start_file_DT.yxmd

OllieClarke

🎵Voorhees a jolly good fellow...

Spoiler

challenge_241_OC_solution.yxmd

sara_burk

Spoiler

challenge_241_SB.yxmd

apurvag95

Screenshot (1).png

gregurbanowicz

Fun one! Solution attached.

challenge_241_Greg_Urbanowicz.yxmd

NithinK

Spoiler

challenge_241_solution_knk.yxmd

phottovy

Fun:

Spoiler

challenge_241_ph_solution.yxmd

scbrownsr

Spoiler

I got a result of 121 instances of Friday the 13th. And no there are no years that do not have a Friday the 13th. Sorry, Jason... No time off.

challenge_241_start_file.yxwz

RobertW

I used the input to make the workflow a little more dynamic. You could change the date or day of week and the workflow still works...

Spoiler

challenge_241_start_file.yxmd

ggruccio

Solution attached.

Spoiler

I also tried years between 1600 and 9999 and couldn't find any that would not contain a Friday the 13th,..maybe only in cases where years were skipped due to calendar corrections? I've read about cases like that during the Renaissance?