That worked but I worded the problem wrong.
I have a part inducted on 1-1-06 that has a life span of 1825 days. How can
I create a formula that will give me the days remaining in a column and have
that number updated daily? I'm using Excel 2003.

"Ardus Petus" wrote:

=DATEDIF(date1, date2,"d") for days between date1 & date2

HTH
--
AP

"Brandon" a écrit dans le message de
...
I have a spreadsheet with a date inducted and a date it needs to be
replaced.
How do I get a cell with the remaining days between the dates and it
update
daily?

"Ardus Petus" wrote:

=DATEDIF(date1, date2,"y") for years
=DATEDIF(date1, date2, "ym") for extra months

HTH
--
AP


"David Picken" <David a écrit dans le
message de ...