Excel Formulas: Check Last N Weeks of Today’s Date ~ Easy Solution!!

So far we have learned the basic formulas for finding the last N daysandlast N months in Excel. Suppose, you need to check if the date is placed within the last N weeks from today. How could you find them? Today I will introduce several tricks to achieve it. Let’s begin!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

  • Use the below formula to check the last N weeks of today’s date in Excel.

=AND(A1>=TODAY()-WEEKDAY(TODAY(),3)-(n*7),A1<TODAY()-WEEKDAY(TODAY(),3))

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.
  • WEEKDAY – This function returns a number (ranging from 1 to 7) that represents the day of the week for a given date. Read more on the WEEKDAY function.
  • A1 – It specifies the input dates from your worksheet.
  • Multiplication (*) – In this symbol will multiply any two values or numbers.
  • 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.

Example:

Let’s consider the below example image.

  • First, we will enter the input dates in Column B.
  • Here we have to check if the given date is within the last N weeks of days from today.
  • For Example, we will specify the N number of weeks as 4.
  • 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.

Bottom-Line:

Hope you like this article on how to check the date last N weeks of today’s date in Excel. Mention your queries in the comment box below.

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

Read Ahead:

19

Tags:

ExcelformulaExcelformulas