Formula First Monday of the month with Excel

Formula First Monday of the month with Excel
Last Updated on 09/07/2023
Reading time: < 1 minute

How to calculate the first Monday of the month by formula with Excel?

Excel formula to calculate the First Monday of the Month

To calculate the first Monday of the month automatically according to the date of today, the formula is:

=TODAY()-DAY(TODAY())+8-WEEKDAY(TODAY()-DAY(TODAY())+6)

First Monday of the Month Excel

But, if you want to calculate the first Monday of the month from another date in B1 for instance, the formula is:

=B1-DAY(B1)+8-WEEKDAY(B1-DAY(B1)+6)

First Monday of the Month Excel for any date

Other formulas for Monday

Leave a Reply

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

Formula First Monday of the month with Excel

Reading time: < 1 minute
Last Updated on 09/07/2023

How to calculate the first Monday of the month by formula with Excel?

Excel formula to calculate the First Monday of the Month

To calculate the first Monday of the month automatically according to the date of today, the formula is:

=TODAY()-DAY(TODAY())+8-WEEKDAY(TODAY()-DAY(TODAY())+6)

First Monday of the Month Excel

But, if you want to calculate the first Monday of the month from another date in B1 for instance, the formula is:

=B1-DAY(B1)+8-WEEKDAY(B1-DAY(B1)+6)

First Monday of the Month Excel for any date

Other formulas for Monday

Leave a Reply

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