Display the "week of" for a given date starting with Monday

[Meredith_Rimmer]

Hi! I’m trying to create a formula that would display a “week of” for a given date where Monday is the start date of the week. The below is the formula I came across on Airtable’s blog - it works great except it displays the start of the week’s date beginning with Sunday. My formula expertise is very limited so there might be a very simple solution to this - I just can’t seem to find one. Any help would be greatly appreciated!

CONCATENATE(“Week of”," ",DATETIME_FORMAT(DATEADD({Date},-DATETIME_FORMAT({Date},‘e’),‘days’),‘M/D’))

[augmented · Accepted solution]

Try this:

DATETIME_FORMAT({Date},‘e’)+1,‘days’),‘M/D’))