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.

  • EExmannhotmailcom's avatar
    EExmannhotmailcom
    Copper Contributor
    May 30, 2020

    Riny_van_Eekelen I'm getting an error with this formula: "To Few Arguments entered", checked all brackets, checked all arguments as you gave in your example, but keep getting the error. Thanks for your effort.

     

    Kind Regards, Eddy

  • 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.