Forum Discussion

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

Diamond Contributor

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.

Mike_Blinn
Copper Contributor
Jul 28, 2020
SergeiBaklan

Will this work if you only have the year?? Thanks!!!
- TheAntony
  Iron Contributor
  Jul 28, 2020
  Mike_Blinn , If you only have the year, just remove the Year function in SergeiBaklan 's formulas:
  =IF(MONTH(DATE(A1,2,29))=2,"leap", "not leap")
  =IF(DAY(DATE(A1,3,0))=29,"leap", "not leap")
  
  Love the simplicity and elegance of the formulas, SergeiBaklan !
  - Mike_Blinn
    Copper Contributor
    Jul 29, 2020
    Thanks you TheAntony !!
- mtarler
  Silver Contributor
  Jul 28, 2020
  Mike_Blinn SergeiBaklan 's formula will work for any date in that year. If you are going to pass only a number (e.g.. 2020) then you could use:
  =IF(MONTH(DATE(A1,2,29))=2,"leap","no leap")
  again where cell A1 has the year number you are asking about.
  - EExmannhotmailcom
    Copper Contributor
    Jul 29, 2020
    mtarler I Think that is correct, since January 1st of March 1st or any day in that given year will of will-not be in part of a Leap Year.