two little puzzles

Puzzle 1)

Since today is Friday the 13th it occurred to me while jogging this morning that I wondered if there could be a formula to determine the highest number of Friday the 13ths there can be in one year.
I searched the forum and found this link https://www.excelforum.com/the-water...-the-13th.html where it was discussed about calculating how many Friday the 13ths you lived through but not how many (min and max) there can be in a year.
My suspicion is that the most there can be is 3 but I have no calculation for it, just logic.
Can you develop a formula that shows the most there can be and the fewest?

Puzzle 2)

Recently we had Easter for most of the Christian world (though what follows is non-denominational / non-religious) at some point in the early church it was determined that Easter would fall on the first Sunday following the first full moon following the vernal equinox. The equinox is a fixed date so (though it does vary but this year it was 3/20/2018), what is the earliest (this is the easiest to determine) and the latest dates that Easter can fall on (I know you can look them up but I am hoping to see formulas)?

I'm looking forward to the responses, enjoy.

Here's one way to show that there is a minimum of 1 Friday the 13th and a maximum of 3 Friday the 13th's for every year.

Change the starting day of the year in cell B1 to all values (0 through 6 representing Sunday through Saturday).

You will see that for all values 0 through 6, the number of Friday the 13th's will be either 1, 2, or 3.

See attachment.

63FD, that was an interesting way to set that up. I like following your thought process in the sheets. I knew you could have two back to back whenever it occurs in February and it isn't a leap year then one will follow in March and your table showed it.
Nice job!

Pete, did you get that from a table or did you calculate it? (just curious)

As for Easter, I wasn't looking for calculators but a possible formula for the latest. My suspicion is the latest could be April 24 and I was reasoning that if the first day of spring is 3/20 and it is also the date of the full moon and it is also Sunday then 28 days later would be the first full moon after the vernal equinox which would be 4/17 which would also be a Sunday so if it is the first Sunday following it that would put it as late as 4/24. Thanks for participating and if you have more to add I look forward to it.

Interesting Tim, nice job. I always love seeing the different ways people come up with to solve problems.

I'll have to take your word for it sandy, I tried to download power query but apparently it didn't work and so I can't tell what your sheet is supposed to do.
thx for taking part.

Got it to download, I'll have to see what it can do and how it functions. thanks.

at least one can see the formulas so another can understands how to do it
made formulas shorter

Nice compilations of formulas to get the counts/year and their dates tim!