Discover a simple Excel formula to find the date for Monday 2 weeks ago from any chosen date!
This easy-to-use technique empowers you to swiftly locate the Monday date that occurred two weeks before your specified date.
Whether you’re 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 2 weeks ago
To automatically determine the date for Monday two weeks prior based on today’s date, use the following formula:
=TODAY()-WEEKDAY(TODAY()-1)+1-7*2
But, if you want to calculate the Monday 2 weeks ago from another date in B1 for instance, the formula is:
=B1-WEEKDAY(B1-1)+1-7*2
Formulas to calculate Monday for any previous weeks
If you wish to calculate Monday from three or four weeks ago, adjust the last value in the formula accordingly.
What about the other days of the week?
To calculate Tuesday from two weeks ago, adjust the value following the TODAY function.
=TODAY()-WEEKDAY(TODAY()-2)+1-7*2
And for Friday 2 weeks ago
=TODAY()-WEEKDAY(TODAY()-5)+1-7*2
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.
