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

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 the Excel EDATE Function to Find If a 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:

• 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:

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

2. Check If a 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:

• 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:

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

3. Combine YEAR, DATE & MONTH Functions to Find If a 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:

• 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:

• 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:

• 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.

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:

• 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.

Download Practice Book

You can download the practice book from here.

Conclusion

In this article, we have 5 easy methods to Find If a Date Is Within 3 Months in Excel. I hope this article will help you to perform your tasks efficiently. Furthermore, we have also added the practice book at the beginning of the article. To test your skills, you can download it to exercise. Lastly, if you have any suggestions or queries, feel free to ask in the comment section below

<< Go Back to Dates | Compare | Learn Excel