subtracting dates

  • Thread starter Thread starter Debbie
  • Start date Start date
D

Debbie

Hi, is there a way to subtract two dates to give you an
age.
In one column I have student birthdates and in another I
have student start dates. I need to calculate their age
on the day they started.
ie)
birthdate start date
16-dec-1968 13-sep-2003

I want the result to say 34.

Thanks
Debbie
 
=DATEDIF(A1,B1,"Y")

where A1 holds the DOB and B1 the day the student started

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top