Rolling 30 Day Total
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!
|