Calculating the age during operation as an integer

[secoo140]

Hello there
I only know the birth dates of the patients.
I am trying to learn their age as an integer from a fixed operation date.

1965 birth date
3.3.2015 operation date
Which formula can I perform this calculation with excel 2010?

thanks

 

[jasonb75]

Try

=DATEDIF(birth date, operation date,"y")

 

[vmjan02]

@secoo140

Patient Birth Date	Operation Date	No or Years (Result)
1965	3.3.2015	50

result formula
=(RIGHT(G2,4))-F2

column G contains Operation date
Column F contains Patient Birth Date

 

[jasonb75]

1965 is a birth year, not a birth date. The question is misleading.

My suggestion will work with a birth date, not a birth year. vjman02's suggestion will work with a birth year but only of the operation date is text, not a valid date.

Book2
	F	G	H
2	1965	03/03/2015	101.00
Sheet4

Cell Formulas
Range	Formula
H2	H2	=(RIGHT(G2,4))-F2