Currently I use the attached workbook to manage my flight hours. I need to implement a form of fatigue management so I need to start having a rolling 30 day total on my daily flight hours. If you look on the March Tab, I have a SUMIF formula in Column R, Row 38 that totals the hours from Column F for the previous 30 days.



For other days I will need to reference the previous sheet.

My question is: How do I do that?

Any assistance would be greatly appreciated.

Thank you!

Attached Files

30 Day Running Total TEST Duty Log 2015.xls (172.5 KB, 16 views)