Skip to main content
Solved

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

  • February 7, 2021
  • 1 reply
  • 65 views
M

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

Best answer by augmented

Try this:

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

P

1 reply

A
Forum|alt.badge.img+18
  • augmented
  • Inspiring
  • Answer
  • February 8, 2021

Try this:

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

D
P
Terms & ConditionsAccessibility statement