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.

excel if date is within 3 months


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))

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

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 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))

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

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.

Read More: How to Compare Dates in Two Columns in Excel


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))

Check If Date Is Within 3 Months Using Excel EOMONTH Function

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))

Check If Date Is Within 3 Months Using Excel EOMONTH Function

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


Similar Readings:


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.

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


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)))

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

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.

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


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)))

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

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.

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

Read More: How to Compare If Date Is Before Another Date in Excel


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")

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

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

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

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

Read More: Check If Date Is 7 Days of Another Date in Excel


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.

Insert Conditional Formatting to Highlight When Date Is Within 3 Months

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.

Insert Conditional Formatting to Highlight When Date Is Within 3 Months

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

Read More: Excel Conditional Formatting for Date Within 3 Months


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


Related Articles

Mursalin Ibne Salehin
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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo