Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Formula to return date of "Monday"?

Topic Labels: Formulas
3288 3
Showing results for 
Search instead for 
Did you mean: 

I’m wondering if there’s a formula that will return the date of a specific weekday, such as Monday, relative to a set date field. Any ideas?

3 Replies 3

You can use DATETIME_FORMAT({Field with datetime}, 'dddd') to return Monday, Tuesday, etc. For more info on this, check out this support article on format specifiers for DATETIME_FORMAT.

Sorry, I don’t think I was clear–what I meant was, let’s say this record is dated 3/7/18. I’d like to calculate the date of the Monday of that week. In this case, it would be 3/5/18. I did just discover the “WEEKNUM()” function, and that helps to an extent, but could it be combined with others to do this task? Thanks!

Try this:

DATEADD(date, 1-IF(WEEKDAY(date)=0, 7, WEEKDAY(date)), 'day')