Subtracting dates

[Guest]

Hi,

Using Excel 2000 on MS Win. XP, I want to subtract one
date from another to determine the age in yrs of an entity
on a particular day. E.g. Content of cell C2 is 08-Jan-86
and that of D2 is 05-Jan-04 if the formula in E2 is =D2-C2
the result shown is 05-Aug-17. "17" happens to be the
right age in yrs but how can I extract that number/value
from the rest of the resulting date? How does Excel in
fact compute the result 05-Aug-17?

Look forward to your help, regards, Karen
(City University, London, UK)

 

[vtisix]

try:

=abs(year(d2)-year(c2))

 

[vtisix]

Actually, that formula will only return full years.

You need to install the Analysis ToolPak in Tools > Add-Ins, then use
formula:

=int(yearfrac(d2,c2,1))