Calculated Column – get first Monday on the next month

If you have a column Data1 – DateTime type column , only date – and you need to get first Monday of the following month, the needed formula in a calculated column will be:


Depending on your regional settings, maybe is necessary to replace “;” with “,”

In my env., Sunday is the first day in the week

The conditions


get which day will be the first day in the next month. ( 1 is for Sunday
7 Saturday, 6 Friday…. , 2 Monday )
Based on your env, change these values, but only the red values

This entry was posted in CalculatedColumn, Sharepoint Online. Bookmark the permalink.