Calculate Monday 2 weeks ago with Excel

Calculate Monday 2 weeks ago with Excel
Last Updated on 18/04/2024
Reading time: 2 minutes

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

Excel formula to calculate monday 2 weeks ago

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

Excel formula to calculate monday 2 weeks ago from any date

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.

Excel Formula for Monday for any previous week

What about the other days of the week?

To calculate Tuesday from two weeks ago, simply 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 to calculate any day of the week, making date calculations a seamless task.

Other formulas for Monday

Check out these additional articles that explore different methods for calculating Mondays within a week or month.

Leave a Reply

Your email address will not be published. Required fields are marked *

Calculate Monday 2 weeks ago with Excel

Reading time: 2 minutes
Last Updated on 18/04/2024

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

Excel formula to calculate monday 2 weeks ago

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

Excel formula to calculate monday 2 weeks ago from any date

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.

Excel Formula for Monday for any previous week

What about the other days of the week?

To calculate Tuesday from two weeks ago, simply 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 to calculate any day of the week, making date calculations a seamless task.

Other formulas for Monday

Check out these additional articles that explore different methods for calculating Mondays within a week or month.

Leave a Reply

Your email address will not be published. Required fields are marked *