View original (French)

53 Sundays in a year

Solved
idefix04 -  
Hello,

For a problem, I need to know which years have 53 Sundays between 2012 and 2030.

Thanks

2 answers

  1.  cousinhub29
    Good evening,

    For your information, the years with 53 Sundays are:

    2012, 2017, 2023, and 2028

    Have a good evening
    0
    1. eriiic Contributor
      Good evening,

      A formula to find them.
      With the year in aaaa format in A1:
      =IF(OR(WEEKDAY(DATE(A1,1,1),2)=7,AND(MOD(A1/4,1)=0,WEEKDAY(DATE(A1,1,1),2)=6)),"53 sun.","52 sun.")

      This formula needs confirmation, but we find the years from cousinhub29.
      Not valid for 2000, 2400, etc.

      eric

      edit: replace "53 sun." with "53 sun." and the same for 52.
      0