Brandon Wrote:
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
...
In general to get the difference in days between two dates you only
need
=B1-A1 where B1 is the later date
format as general
In your case it looks like you need the difference in days between
today and your replacement date - if replacement date in in C1
=C1-today()
format as general
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=524789