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.

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 *!! **

Read Also:

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

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

Excel Formulas to Find a Nth Day of Week in a Month ~ East Tricks!!

How to Enter a Time in Excel Worksheet? ~ A Useful Guide!!