Help

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

Solved
Jump to Solution
1103 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Meredith_Rimmer
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Solution

Accepted Solutions
augmented
10 - Mercury
10 - Mercury

Try this:

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

See Solution in Thread

1 Reply 1
augmented
10 - Mercury
10 - Mercury

Try this:

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