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.

EricStarker's avatar
EricStarker
Former Employee
May 27, 2020

EExmannhotmailcom 

Hello! You've posted your question in the Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future. 

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

    EricStarker  Sorry that was not my intend, I'm new here and could not find a solution within Excel (standard formula) to calculate if a date(year) is actualy a leap-year. In my old days as system programmer on main frames there where standard routines you could execute giving it a date and getting back details including if it was in a leap year.

    Thanks for your action.

    Kind regards, Eddy