Hi Guys,
I need help with a 90 rolling period formula. Ive tried to use Index but can quite come up with the right formula for it. I have attached a sample of the sheet.
What I need is whenever I input a date into Column A I need it to calculate rolling down the sheet if there is an infraction which will give me the number in the red column. This needs to keep going down the sheet every time there is another date/Infraction if it falls in the 90 days.
Thanks for the help
Mikeydaman
Bookmarks