difference between years

[rahul]

Hi,

For my company purpose i need to take the exact age of
customer.for that i need a formula,so that if i enter
users date of birth in one column & present date in
another colunm i should get the exact age of user.Please
help me regarding this

with regards
Rahul

 

[HM]

Follow this link to Chip Pearson's pages
http://www.cpearson.com/excel/datedif.htm#Age

 

[J.E. McGimpsey]

take a look at DATEDIF():

http://cpearson.com/excel/datedif.htm

 

[Gerrit]

Hi,

For my company purpose i need to take the exact age of
customer.for that i need a formula,so that if i enter
users date of birth in one column & present date in
another colunm i should get the exact age of user.Please
help me regarding this

with regards
Rahul

age is:
=Datedif(A1;A2;"Y")
see:
http://www.cpearson.com/excel/datedif.htm

 

[2rrs]

You can use this without the need for a 2nd col:

=DATEDIF(A2,NOW(),"y")&" years, "&DATEDIF(A2,NOW(),"ym")&" months,
"&DATEDIF(A2,NOW(),"md")&" days"

If a separate col is preferred; substitute that cell ref for "NOW"