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