How do I find the length of time (Years & Months) between 2 dates

A

Ardus Petus

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

HTH
 
B

Brandon

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?
 
J

JE McGimpsey

One way:

A1: <date inducted>
A2: <date to be replaced>
A3: =A2-A1

format A3 as General or Number.

No idea how to update it daily unless you specify how either of the
dates change.
 
D

daddylonglegs

Brandon said:
I have a spreadsheet with a date inducted and a date it needs to b
replaced.
How do I get a cell with the remaining days between the dates and i
update
daily?
Click to expand...

In general to get the difference in days between two dates you onl
need

=B1-A1 where B1 is the later date

format as general

In your case it looks like you need the difference in days betwee
today and your replacement date - if replacement date in in C1

=C1-today()

format as genera
 
B

Brandon

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

daddylonglegs

Is that not correct? You wanted the days remaining. If it shows 174
today it will show 1744 tomorrow and so on until it reaches zero o
31st December 2010
 
B

Brandon

Well of course had I closed the application and reopened it and used my
brain. Thank you so much for all the help. It seems to work like a charm.
I will try it on the main sheet and see what happens. This has been very
helpful.
 
B

Brandon

Does the 360 days a year affect the calculations? I saw where Excel uses 360
days in the year instead of 365.
 
D

daddylonglegs

Using the formula I posted the calculation will be correct. There is a
DAYS360 function in Excel which uses a 360 day year for accounting
purposes but, other than that Excel will calculate using 365 day or 366
day years as appropriate
 
Top