Rolling running total by date
That formula assumes a continuous run of dates, such May 1 to May 31.
It considers days that do not have an entry of flight hours and
includes those zero or null values in the calculation. To test, set
up a series of 28 days all with one hour entered: your total should be
28. Delete some of the ones at random to signify non-flying days, and
your total will reduce accordingly.
|