# 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)

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)

# 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)

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

{"mobile_concate":{"mobile-menu":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/mobile-menu.css"},"tf_base":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/themify\/css\/base.min.css","v":"7.6.0"},"themify_common":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/themify\/css\/themify-common.css","v":"7.6.0"},"builder-styles-css":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/themify-builder-style.css","v":"7.6.0"},"tb_tbp":{"s":"https:\/\/excel-tutorial.com\/wp-content\/plugins\/themify-builder-pro\/public\/css\/tbp-style.css","v":"3.6.0"},"tf_theme_site-logo":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/styles\/modules\/site-logo.css","v":"7.5.5"},"tf_search_form":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/themify\/css\/modules\/search-form.css","v":"7.6.0"},"tb_featured-image":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/image.css","v":"7.6.0"},"tb_divider":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/divider.css","v":"7.6.0"},"tb_post-content":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/text.css","v":"7.6.0"},"wp-block-library":{"s":"https:\/\/excel-tutorial.com\/wp-includes\/css\/dist\/block-library\/style.min.css","v":"6.5.3"},"tb_comments":{"s":"https:\/\/excel-tutorial.com\/wp-content\/plugins\/themify-builder-pro\/public\/css\/modules\/comments.css","v":"3.6.0"},"tb_image":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/image.css","v":"7.6.0"},"tb_app":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/appearance.css","v":"7.6.0"},"tb_image_top":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/image_styles\/top.css","v":"7.6.0"},"tb_text":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/text.css","v":"7.6.0"},"theme-style":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/style.css","v":"7.5.5"},"themify-media-queries":{"s":"https:\/\/excel-tutorial.com\/wp-content\/themes\/themify-infinite\/media-queries.css","v":"7.5.5","m":"(max-width:1200px)"}}