date functions

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

Debbie

Hi, I need to know if I can subtract to date columns and
have them appear as a year. I have student birthdates and
student start dates and need to identify their age when
they started.

IE:
Birthdate: Start Date:
16-dec-1968 13-sep-2003

The result I want is 34.

Thanks.
Debbie
 
Debbie,

here is one way

=YEAR(B22)-YEAR(A22)-(MONTH(B22)<MONTH(A22))-(AND(MONTH(B22)=MONTH(A22),DAY(
B22)<DAY(A22)))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Say Birthday is on A1 and Startdate is on B1 try...

=int((b1-a1)/365)

Leap years may make it vary but I don't it could be an
issue...
 
Another idea to get rid of the leap years issue is:
=--RIGHT(YEAR(B1-A1),2) or
=VALUE(RIGHT(YEAR(B1-A1),2))
 
Hi Debbie!

Another way:

=DATEDIF(A1,B1,"y")

It has the advantage that it will return the age correctly when the
date is the same day and month of year. The problem with using days in
year approximations is that they are only averages.

See:
Chip Pearson:
http://www.cpearson.com/excel/datedif.htm
Full gory history and details of this function.
 
Back
Top