Formula First Monday of the month with Excel

Reading time: < 1 minutes
Last Updated on 16/05/2023 by Frédéric LE GUEN

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 minutes
Last Updated on 16/05/2023 by Frédéric LE GUEN

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 *