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 Next Monday
• Monday in two weeks
• Previous Monday
• Monday previous week
• Monday 2 weeks ago
• First Monday of the Month