Table of Contents
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:
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.