Re: Formula to return date of "Monday"?

1300 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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