*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