LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 460
Default Days Since Report Was Run

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pls help to find number of days for ageing report pol Excel Discussion (Misc queries) 3 December 2nd 09 12:16 PM
Need to pull <=14 Days, <=30 Days, 30 Days from a date column Ken Excel Discussion (Misc queries) 3 October 23rd 09 12:53 AM
report date - date rec.ved=days late, but how to rid dates complet MS Questionnairess Excel Worksheet Functions 3 January 25th 07 06:17 PM
Report Date - Date Recv = Days Late, but how to rid completed date MS Questionnairess Excel Worksheet Functions 1 January 24th 07 11:05 PM
Report a given number in days:hours:minutes ? TigerLord Excel Discussion (Misc queries) 2 March 26th 06 08:25 PM


All times are GMT +1. The time now is 04:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"