View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave O[_2_] Dave O[_2_] is offline
external usenet poster
 
Posts: 19
Default 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.