finding age from dob without using datedif

[lezawang]

Hi
I watched many youtube video/googled it etc. All of them used DateDif() and the funny thing they all said the datedif() is a legacy function. Then I am wondering why they are using legacy function and why they do not trying to use something different, I am sure Excel team came with something to replace dateif() but I do not know what is it exactly. How you will calculate age from DOB? Thank you very much.

 

[Fluff]

How you will calculate age from DOB?

With the DateDif function.
It has not been replaced by any other function.

 

[alansidman]

DateDif is a carry over from LOTUS123. If you are insistent upon not using it then you could always subtract the DOB from Today() and divide by 365.25

 

[lezawang]

Thank you, I thought that function will not be supported in the future.. that is why I was wondering why they kept using it. Thank you again

 

[Fluff]

They may get rid of it one day, but that could happen with any function.

 

[alansidman]

It is listed as an unsupported function.

 

[jtakw]

Hi,

You can also use YEARFRAC:

Book3.xlsx
	A	B
1	DOB	AGE
2	12/25/1964	56
Sheet747

Cell Formulas
Range	Formula
B2	B2	=INT(YEARFRAC(A2,TODAY(),1))