Age Calculation

M

Muntasar

Hi,
Is it possible to calculate age in an excel sheet? How?

My friends birthday is 17-09-1970, today is 25-08-2003.
Today how old is he?

Thanks
 
L

Lydya

A1= 17/09/1970
B1= 25/08/2003
C1=DATEDIF(A1,B1,"y")
The third argument of the function is the time unit you want to calculate (y
= years, m=months, d=days ...)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

New computer, how do i move outlook 365 ENTIRELY? 0
Calculate horses age as at 1 August 6
Display weeks from a Milestone 0
Age Calculator 1
Convert Age to Months 3
Calculate age 13
How do I calculate a persons age from birth dates 1
How to calculate Age 4

Top