Running Total for days/dates

[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.

 

[Jason Morin]

=TODAY()-DATEVALUE("5/25/03")

Change the date above to your actual start date.

HTH
Jason
Atlanta, GA

 

[Lisa Boreanaz]

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

 

[Jason Morin]

=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
.

 

[2rrs]

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