Tracking hours with multiple calculations for various time spans

[surveyair]

Hi, I am looking to make a sheet to track pilot hours over a period of years and for each day calculate the hours flown in the last 7 days, 30 days, 42 days, 90 days, 180 days and 365 days. I am looking to make it multiple years since we need to track it for years without needing to add another year and then reenter all the previous information.

 

[surveyair]

Thanks for the help getting this working the way we needed it. Solved

 

[markmzz]

Thanks for the help getting this working the way we needed it. Solved

Surveyair,

Thanks for the feedback.

Markmzz