You can use the following **IF** function in Excel to return a specific value if the month in a given cell is January:

=IF(MONTH(A2)=1, "Yes", "No")

For this formula, if the month of the date in cell **A2** is January then this function returns “Yes.”

Otherwise it returns “No.”

The following example shows how to use this function in practice.

**Example: Excel Formula to Check If Month is January**

Suppose we have the following dataset in Excel that shows the total sales made on various dates at some company:

We can type the following formula into cell **C2** to check if the date in cell **A2** is in January and return “Yes” or “No” as a result:

=IF(MONTH(A2)=1, "Yes", "No")

We can then click and drag this formula down to each remaining cell in column C:

Column C now contains “Yes” or “No” to indicate if the month in each date in column A is January or not.

**How This Formula Works**

Recall the formula we used to check if the month of the date in cell **A2** is January:

=IF(MONTH(A2)=1, "Yes", "No")

Here is how this formula works:

The **MONTH** function in Excel returns an integer value between **1** and **12** to indicate the month number of a specific date.

If a date in a particular cell is in January, then the **MONTH** function will return **1**.

By using **MONTH(A2)=1** we return **TRUE** or **FALSE** to indicate if the month in a specific date is in January.

We then use a simple **IF** function to return “Yes” if the result is **TRUE** or “No” if the result is **FALSE.**

**Note**: You can easily modify this formula to check if a given date contains a different month.

For example, you could use the following formula to return “Yes” or “No” to indicate if a given date contains “October” as the month:

=IF(MONTH(A2)=10, "Yes", "No")

Feel free to use whichever integer value you’d like in the formula depending on which month you’d like to use.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Excel:

Excel: Calculate the Number of Months Between Dates

Excel: How to Calculate Sum by Date

Excel: How to Calculate Average by Date