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.  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
    1. cousinhub29
      Good evening,

      For your information, the years with 53 Sundays are:

      2012, 2017, 2023, and 2028

      Have a good evening
      0