Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula to find date of specific day prior to designated date.

Topic Labels: Dates & Timezones Formulas
582 1
cancel
Showing results for 
Search instead for 
Did you mean: 
meganrobert
4 - Data Explorer
4 - Data Explorer

I am trying to figure out the formula to populate the date of a specific day in relation to a designated date.

Below are some examples of what I mean.

I have a date field titled EVENT DATE. I want the column titled PAYMENT DUE to populate the date of five Fridays prior to the event's date aka EVENT DATE.

It seems like this should be so simple and/or already a question asked. But I am having a hard time finding a question similar to this.

1 Reply 1
Sho
11 - Venus
11 - Venus

Like this?

DATEADD({Date},-(5+WEEKDAY(DATEADD({Date},-3,"days"))),"days")