Excel Rolling 2-year totals
EXCEL Question: How to I check that my totals over the past 730 days (rolling 2 years) exceed the mandatory 12 hours? I’ve got as far as plotting 2 years ago (easy: TODAY()-730), finding the first subsequent flight date (INDEX… MATCH…), and retrieving the hours flown on that flight (VLOOKUP). But I can’t find a way to sum all the hours from that flight to now. I’ve resorted to the million monkeys technique but I clearly don’t have enough monkeys or typewriters. There must be a way, pleeeeease.
PS I don’t care if its decimal hours, I can manage that; real hours:minutes would only be the cherry on a cake which I can’t bake.
PPS SUMIF works but only for the latest date; it must be possible to look back and see when I got close to the limit
Last edited by Manchester; 24th May 2019 at 16:20.