Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 25, 2024 10:00 AM
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

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 25, 2024 06:28 PM
Like this?
DATEADD({Date},-(5+WEEKDAY(DATEADD({Date},-3,"days"))),"days")
