Calculating the Time between dates

[BStats]

Hi,

I have two dates in my data set and I need to calculate each persons age at the time of the second date. How can I do this? I have provided the formate in wich the dates are stored in my dataset below.

ID         DOB                  Medication

1         01JAN1988          23DEC2006

2         10MAY1962         09FEB2010

-Thx

[Haikuo · Accepted solution]

Check out YRDIF() function with 'AGE' argument.