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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DOUG" wrote in message
...
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