Hi all,
I am looking for tips on how to calculate the last 3 months (or last say, 90 days) from a specific date for individual IDs. As an example, see below. The idea is that I have different event dates and I want to review a summary of their results in a 90 day period prior. Because they have different end dates, I cannot just use a date range filter. Any thoughts?
IDEnd Date
Past 90 Days
AApril 30, 2019?BSeptember 18, 2018?CJuly 16, 2017?
3 answers
Hi Kevin,
Do you mean this?
Make a calcs past 3 month:
DATEADD('month',-3,[End Date])
Workbook attached.
Michael Ye
