Discover the Excel formula for finding the previous Monday from any chosen date! This easy-to-use technique empowers you to swiftly locate the Monday two weeks before your specified date.
Whether planning schedules, tracking deadlines, or analyzing data, mastering this formula will boost your efficiency and make date calculations a breeze in Excel. Say goodbye to manual counting and hello to streamlined workflows with Excel’s intuitive features!
Excel formula to calculate Monday of the previous week
To calculate Monday of the previous week automatically according to the date of today, the formula is:
- The previous situation considers the current-day returns by the TODAY function.
- But, if you want to calculate the next Monday from any date, write it in a cell, like B1, for instance
What about the other days of the week?
To calculate the previous Tuesday, adjust the value following the TODAY function.
=TODAY()-WEEKDAY(TODAY()-1)+2-7
And for Friday
=TODAY()-WEEKDAY(TODAY()-1)+5-7
As demonstrated, Excel offers a straightforward method for calculating any day of the week, making date calculations seamless.
Other formulas for Monday
Check out these additional articles that explore different methods for calculating Mondays within a week or month.
