# How to Find If Date Is Within 3 Months in Excel (5 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

In this article, we will learn to find if a date is within 3 months in Excel. Sometimes, we need to check if a given date is within the next or last 3 months. In Excel, we can easily achieve that using some functions. Today, we will show 5 easy ways. Using these methods, you can easily find or check if a date is within 3 months. So, without further delay, letâ€™s start the discussion.

## How to Find If Date Is Within 3 Months in Excel: 5 Easy Ways

To explain the methods, we will use a dataset containing some projectsâ€™ End Dates. We will find out if the End Date is within 3 months from the Current Date. Here, the current date is the date when you are applying the formula. We will also show the formula for the range of 3 months. So, pay attention to the methods below to learn more.

### 1. Apply Excel EDATE Function to Find If Date Is Within 3 Months

In the first method, we will use the EDATE function to find if a date is within 3 months. To build the formula, we will also take the help of the AND function and the TODAY function. We can check if a date is within the next 3 months. Also, we can show if a date is within the last 3 months. In the following sub-section, we will demonstrate both formulas.

#### 1.1 Within Next 3 Months

To determine if a date is within the next 3 months, you must follow the steps below carefully.

STEPS:

• First of all, select Cell D5 and type the formula below:
`=AND(C5>TODAY(),C5<=EDATE(TODAY(),3))`

In this formula, we have used the AND function. If both logic inside the AND function is correct, then it will TRUE, otherwise FALSE.

• Logic 1 declares Cell C5 is greater than the date of today. The TODAY function returns todayâ€™s date.
• Logic 2 denotes Cell C5 should be less than or equal to the date of 3 months from today. Here, the EDATE function returns the serial number of a date.
• After that, press Enter and drag the Fill Handle down to see the results.
• From the results, we can say the End Date of Project 2 is within the next 3Â months.

#### 1.2 Within Last 3 Months

To check if a date is within the last 3 months, we need to make slight changes to the previous formula. Letâ€™s follow the steps below to see how we can implement this idea.

STEPS:

• Firstly, select Cell D5 and type the formula below:
`=AND(C5<TODAY(),C5>=EDATE(TODAY(),-3))`

This formula is similar to the previous one. But the logic is different. Logic 1 says Cell C5 should be less than the date of today and Logic 2 denotes Cell C5 should be greater than or equal to the date of the last 3 months from today. Also, to calculate the last 3 months, we have used the minus (â€“) sign in place of the plus (+) sign.

• Finally, hit Enter and drag down the Fill Handle to see which dates satisfy the conditions.

### 2. Check If Date Is Within 3 Months Using Excel EOMONTH Function

We can also use the EOMONTH function to check if a date is within 3 months. The EOMONTH function returns the serial number of the last day of a month. We can divide the method into two subsections.

#### 2.1 Within Next 3 Months

To see if a date is within the next 3 months, you need to follow the steps below.

STEPS:

• In the first place, select Cell D5 and type the formula below:
`=AND(C5>EOMONTH(TODAY(),0),C5<=EOMONTH(TODAY(),3))`

In this formula, we have used the combination of the EOMONTH and TODAY functions to get the dates.

• EOMONTH(TODAY(),0): This part denotes todayâ€™s date.
• EOMONTH(TODAY(),3): This indicates the last date of the 3rd month from todayâ€™s date.
• After that, press Enter.
• Then, drag down the Fill Handle.
• Finally, you will get the desired results.

#### 2.2 Within Last 3 Months

• Similarly, to find if a date is within the last 3 months, then u need to apply the formula below.
• Select Cell C5 and type the formula below:
`=AND(C5<EOMONTH(TODAY(),0),C5>=EOMONTH(TODAY(),-3))`

You can see the differences between the two formulas by taking a look at them. Here, we have added a minus (â€“) in front of 3 and changed the greater than and less than symbols.

• Lastly, press Enter and copy the formula down to see which dates satisfy the conditions.

Read More: Excel Formula If Date Is Less Than Today

### 3. Combine YEAR, DATE & MONTH Functions to Find If Date Is Within 3 Months

Another way to find if a date is within 3 months is to use the combination of the YEAR, DATE, and MONTH functions. To implement this method, you need to insert the current date in a cell on your sheet. Here, Cell C11 contains the current date.

#### 3.1 Within Next 3 Months

In the first subsection, we will find if a date is within the next 3 months. For that purpose, we will have to use the AND, TODAY, DATE, YEAR, MONTH, and DAY functions together. The DATE function expresses a date in the yyyy/mm/dd format. Letâ€™s follow the steps below to see the formula.

STEPS:

• To begin with, select Cell D5 and type the formula below:
`=AND(C5>TODAY(),C5<=DATE(YEAR(\$C\$11),MONTH(\$C\$11)+3,DAY(\$C\$11)))`

In this formula, the output of DATE(YEAR(\$C\$11),MONTH(\$C\$11)+3,DAY(\$C\$11)) is 11/28/2022 with respect to the date 8/28/2022. The conditions of this formula work like the previous ones.

• After that, press Enter and drag the Fill Handle down to get the desired results.

#### 3.2 Within Last 3 Months

• To check a date within the last 3 months, you need to insert the formula below in Cell D5:
`=AND(C5<TODAY(),C5>=DATE(YEAR(\$C\$11),MONTH(\$C\$11)-3,DAY(\$C\$11)))`

Here, the conditions check if a date is within the last 3 months from todayâ€™s date.

• Lastly, hit Enter and drag the Fill Handle down to see the results.

### 4. Print Specific Value If Date Is Within 3 Months Using Excel IF Function

In the previous 3 methods, if a date is within 3 months, then, the output was TRUE. Otherwise, it showed FALSE. We need to use the IF function to show a specific value. Generally, the IF function has 3 arguments; logic, value_if_true, and value_if_false. In the first argument, we need to insert the formula of Method 1.

So, letâ€™s follow the steps below to see how we can implement the method.

STEPS:

• Firstly, select Cell D5 and type the formula below:
`=IF(AND(C5>TODAY(),C5<=EDATE(TODAY(),3)),"Within 3 Months","X")`

If the conditions are true, then the output of this formula will be Within 3 Months. Otherwise, it will show X. You can see we have used the formula of Method 1 in the first argument.

• Now, press Enter.
• After that, drag the Fill HandleÂ down.
• Finally, you will see that the End Date of Project 2 is within 3Â months.

• Moreover, if you want to check if a date is between two specific dates, then you can use the formula below.
`=IF(AND(C5>DATE(2022,7,1),C5<=DATE(2022,10,1)),"Within 3 Months","X")`

Here, we have used the formula to check if a date is between 7/1/2022 and 10/1/2022.

### 5. Insert Conditional Formatting to Highlight When Date Is Within 3 Months

In the last method, we will use Conditional Formatting to highlight when a date is within 3 months. Again, we will use the formula of Method 1. Furthermore, we donâ€™t need extra columns to apply the formula like the previous one.

Letâ€™s follow the steps below to see how we can apply conditional formatting to get the desired results.

STEPS:

• In the first place, select the range C5:C9.

• Secondly, go to the Home tab and select Conditional Formatting. A drop-down menu will appear.
• Select New Rule from there. It will open the New Formatting RuleÂ box.

• In the New Formatting Rule box, select â€˜Use a formula to determine which cells to formatâ€™ from the Select a Rule TypeÂ section.
• After that, click inside the â€˜Format Values where this formula is trueâ€™ box and type the formula below:
`=AND(C5>TODAY(),C5<=EDATE(TODAY(),3))`
• Now, click on the Format option. It will open the Format Cells window.

• In the Format Cells window, click on the Fill tab and choose a color from the Background ColorÂ section.
• Then, click OK to proceed.

• Finally, Excel will highlight the cells that follow the conditions.

## Related Articles

Mursalin Ibne Salehin

Hi there! This is Mursalin. I am currently working as a Team Leader at ExcelDemy. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I manage and help the writers to develop quality content in Excel and VBA-related topics.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF