Let's say that A1 contains the year. To know whether it is a Leap Year or not, use following formula –
=MONTH(DATE(A1,2,29))=2
TRUE means that it is Leap Year and FALSE means that this is not a Leap Year.
Let's say that A1 contains the year. To know whether it is a Leap Year or not, use following formula –
=MONTH(DATE(A1,2,29))=2
TRUE means that it is Leap Year and FALSE means that this is not a Leap Year.
Here are two more formulas that will also produce the same results as your formula….
=DAY(DATE(A1,3,1)-1)=29
=DAY(DATE(A1,1,1)+60)=1
I am not claiming this these formulas are better, not at all, rather, just that they are alternate approaches to the problem. With that said, these formulas as well as yours will incorrectly identify the year 1900 as being a Leap Year (it wasn't). This has to do with a "flaw" built into Excel's date processor. If you would like or need a formula that is correct for all years that Excel is able to work with, give this one a try…
=DAY(DATE(A1+2000,3,1)-1)=29
Minor Correction: That last formula will only work with years up to and including 7999. Hopefully this flaw will not prove to be too restrictive.😁
That's a terrific formula!!!