Excel Formulas: Check the Date is within a Last N months from Today!!

In the previous post, we have learned the formulas to check thelast N days from today in Excel. Likewise, here we are going to check if a date is within the last N months from today in Excel. Let’s jump into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula:

If you want to find the last N months, you can use the below formula.

=AND(A1>=EOMONTH(TODAY(),-(n+1))+1,A1<EOMONTH(TODAY(),-1))

Syntax Explanations:

AND – In Excel, the AND function will help to check Multiple Conditions and returns TRUE if all the conditions are evaluated as true, otherwise returns FALSE.

TODAY – The TODAY function helps to display the current date on your workbook.

EOMONTH – This function returns the last day of the month after adding/subtracting a specified number of months to a date. Read more on the EOMONTH function.

A1 – It specifies the input dates from your worksheet.

Plus operator (+) – This symbol is used to add the values.

Comma symbol (,) – It is a separator that helps to separate a list of values.

Minus Operator (-) – This symbol will help to subtract any two values.

Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Refer to the below example image.

First, we will enter the input dates in Column B.

Now we are going to check if the given date is within the last N number of months from today.

For Example, we will specify the N number of months as 3.

Select any cell and type the above-given formula.

Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.

Verdict:

In this tutorial, we have discussed the simple formulas to check if a date is within the last N months from today in Excel. Hope you like it. If you have any doubts regarding this topic or any other Excel VBA-related topic, ask in the comments section below.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **

Excel Formulas to Get the Number of Workdays between Two Dates!!

Excel Formulas to Calculate the Quarter from the Given Date ~ Easy Tips!!

How to Find the Last Column of Data in Excel Office 365?

How to Validate Only Numbers in Cell in Excel Office 365?