# Formula First Monday of the month with Excel 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)

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)

## Other formulas for Monday # Formula First Monday of the month with Excel

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)

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)