Running Total for days/dates

  • Thread starter Thread starter Lisa Boreanaz
  • Start date Start date
L

Lisa Boreanaz

Does anyone know how I can keep a running total for total
number of days given a known start date? I need to have
an updated total number of days when I open my Excel
spreadsheet.
 
=TODAY()-DATEVALUE("5/25/03")

Change the date above to your actual start date.

HTH
Jason
Atlanta, GA
 
How would I modify this function if the start date was
contained in a reference cell? I have a spreadsheet that
has a column for "date opened" and another column
for "total days open". The previous user would manually
update the total days open on a daily basis. I would like
the spreadsheet to automatically update the total days
open when I open my spreadsheet (there are many, many,
many open items!). Luckily all the dates under the "date
opened" column heading are formatted the same.

Thanks!
Lisa
 
=TODAY()-E1

for example.

HTH
Jason
Atlanta, GA
-----Original Message-----
How would I modify this function if the start date was
contained in a reference cell? I have a spreadsheet that
has a column for "date opened" and another column
for "total days open". The previous user would manually
update the total days open on a daily basis. I would like
the spreadsheet to automatically update the total days
open when I open my spreadsheet (there are many, many,
many open items!). Luckily all the dates under the "date
opened" column heading are formatted the same.

Thanks!
Lisa
.
Click to expand...
 
Lisa,

In the event that you want to track working days in lieu of total days
you could use this:

In the total days open column enter
=NETWORKDAYS(A2,TODAY(),Holidays)......(place Holidays in a named
range)

2rrs
 
Back
Top