Excel Formulas to Check Whether it is a Leap Year or Not ~ Quickly!!

Have you ever tried to find out if the certain date belongs to leap year or not in Excel? In this blog post, we will discuss the easy trick to check whether the year of a certain date is a leap year or not in Excel. Let’s jump into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

If you want to test whether the year of a certain date is a leap year, you can use the below formula.

=MONTH(DATE(YEAR(date),2,29))=2

Syntax Explanations:

NETWORKDAYS – In Excel, the NETWORKDAYS Function helps to return the number of working days between two dates.
DATE – This function will combine three different values and returns them as a date. Read more on the DATE function.
YEAR – It helps to extract the year from the given date and returns the year as a 4-digit number. Read more on the YEAR Function.
Date – It represents the input dates on your worksheet.
Comma symbol (,) – It is a separator that helps to separate a list of values.
Parenthesis () – The main purpose of this symbol is to group the elements.

Example:

Let’s consider the below example image.

Here we will enter the input dates in Column B.
Now we are going to check if the given date belongs to leap year or not.

Select any cell and type the above-given formula.

Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.

Bottom-Line:

From this tutorial, you can get some clarification on how to check whether the date belongs to leap year or not in Excel. Hope you like this article. Mention your queries in the comment box below.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **