Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

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

Topic Labels: Formulas
Solved
Jump to Solution
1673 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Try this:

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

See Solution in Thread

1 Reply 1

Try this:

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