Help

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

460 0
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")