View original (French)

53 Sundays in a year

Solved
idefix04 -  
eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   -
Hello,

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

Thanks

2 answers

  1.
    cousinhub29 Posted messages 1112 Registration date   Status Member Last intervention   383
     
    Good evening,

    For your information, the years with 53 Sundays are:

    2012, 2017, 2023, and 2028

    Have a good evening
    0
  2. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    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