Forum Discussion

EExmannhotmailcom's avatar
EExmannhotmailcom
Copper Contributor
May 23, 2020
Solved

Leap Year

Finaly got a working routine in Excel VBA to calculate if current or specific date is in a leap year. Please send me a note and I will publish the VBA code in English. kind regards, Eddy
  • SergeiBaklan's avatar
    SergeiBaklan
    May 27, 2020

    EExmannhotmailcom 

    Just in case, with formula you may check as

     

    =IF(MONTH(DATE(YEAR(A1),2,29))=2,"leap", "not leap")

or
=IF(DAY(DATE(YEAR(A1),3,0))=29,"leap", "not leap")

or like

     

    if the date is in A1.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 28, 2020

Riny_van_Eekelen 

Small comment - that gives incorrect result for every 100, but not every 400 year. For example year 2100 is not leap.