Excel Formulas to Check the Date is within the Last N Days from Today!!

Are you stuck with finding the date that is within the last N days from today? This article will introduce several tricks to solve them in Excel easily. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

You can use the below formula to check the last N days from today in Excel.

=AND(A1>=(TODAY()-n),A1<TODAY())

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.
A1 – It specifies the input dates from your worksheet.
N – It represents the N number of 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:

Let’s consider the below example image.

Here, 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 days from today.

For Example, we will specify the N number of days as 5.
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.

Wind-Up:

From this chapter, you can get some clarification on how to check the date that is within the last N days of today’s date in Excel. We welcome your comments and questions about this lesson.

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