Days Since Report Was Run

  • Thread starter Thread starter DOUG
  • Start date Start date
D

DOUG

I need to calculate the number of days between when a report was run and the
time before. That is straightforward (R7 - R8) except when the previous date
is repeated over and over again. In other words, I need a running total.
But, if the last time it was run was Sep 08 and the cell below that says Sep
08, the difference between those cells is 0. The number of elapsed days
should build from month-to-month.

DOUG
 
You can always have a macro store the number somewhere and then calculate it
for you. More detail or
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
 
Back
Top