Figure 1. Year is a Leap Year in Excel.
We are going to use a formula that consists of the Excel MONTH, YEAR, and DATE functions in order to ascertain whether the year of a given date is a leap year,
Generic Formula
=MONTH(DATE(YEAR(date),2,29))=2
In the formula above, February has 29 days during a leap year, and the number 2 is for the month of February.
How to use the Excel MONTH, YEAR, and DATE Functions.
We are now going to utilize the Excel MONTH YEAR and DATE Functions in 3 simple steps;
- Enter the day, month, and year values in a column of our worksheet.
Be sure to label a separate column for Excel to indicate which of the dates occur on a leap year.
See example illustrated below;
Figure 2. Year is a Leap Year in Excel.
- In the example illustrated above, we are going to enter the following MONTH, YEAR, and DATE formula into cell B2;
=MONTH(DATE(YEAR(A2),2,29))=2
Figure 3. Year is a Leap Year in Excel.
- After Excel has returned the initial result, copy the formula into the cells down the column for the next results to be returned.
Figure 4. Year is a Leap Year in Excel.
If the year is a Leap Year, the formula returns TRUE and if not, the formula returns FALSE.
However, during non-leap years, the date March 1 of the year will be returned by the DATE Function because the 29th day does not exist.
Instant Connection to an Expert through our Excelchat Service:
Our live Excelchat Service is here for you. We have Excel Experts available 24/7 to answer any Excel questions you may have. Guaranteed connection within 30 seconds and a customized solution for you within 20 minutes
Leave a Comment