You are using terms that are likely intimately familiar to you. However, I do not know exactly what your definition of grace period is or when it starts.
Is 183 days actually days or a supposed to be "6 months" or similar?
@mauri0623 wrote:
Washout is 183 days from the grace period of the one week forward and two weeks backward.
One week forward from which specific date (or exactly how to derive that date given your example data set), similar "two weeks backward" from which date? And weeks may need some clarification. The day at the start of the week? Do you use Sunday, Monday or a different day of the week as start? Or is "week" exactly 7 days? Or the Sunday of the week that is 7 days prior (or after?). Or the first working day of week?
Date intervals need very explicit rules and unfortunately there are multiple definitions of some of these. Look at the WEEK function documentation for example. It has 3 values for a parameter that are involved in defining the starting day of a "week" at the beginning of a year.
You should show an example of the desired output so that we can see how you use your rules and to show the result after the "apply" as in "We also need to apply a washout period." Does apply mean set a flag? Remove observations? Add some value to an existing variable? Create additional observations?
