Date Difference
 

Hi,

My DOB is 2-Feb-1970.. I want to know my age on 1-Jan-2010 in Years,Months
and days for Eg: 10 Years,9 months and 10 days.

How can I do this in Excel?

I took the difference by putting the two dates in two cells and took the
difference. But it is not working,

Thanks!

Date Difference
 

http://www.cpearson.com/excel/datedif.aspx
--
HTH...

Jim Thomlinson


"Maanu" wrote:

Hi,

My DOB is 2-Feb-1970.. I want to know my age on 1-Jan-2010 in Years,Months
and days for Eg: 10 Years,9 months and 10 days.

How can I do this in Excel?

I took the difference by putting the two dates in two cells and took the
difference. But it is not working,

Thanks!

Date Difference
 

DATEDIF will do the job.
Take a look at the pictu
http://img535.imageshack.us/img535/2626/nonamey.png
Micky


"Maanu" wrote:

Hi,

My DOB is 2-Feb-1970.. I want to know my age on 1-Jan-2010 in Years,Months
and days for Eg: 10 Years,9 months and 10 days.

How can I do this in Excel?

I took the difference by putting the two dates in two cells and took the
difference. But it is not working,

Thanks!

Date Difference
 

If your DOB is in cell A1:
=DATEDIF(A1,TODAY(),"y")&" years, "&DATEDIF(A1,TODAY(),"ym")&" months,
"&DATEDIF(A1,TODAY(),"md")&" days"

will tell you info as of today. Or, you can replace all the TODAY()
functions with a cell reference (A2):
=DATEDIF(A1,A2,"y")&" years, "&DATEDIF(A1,A2,"ym")&" months,
"&DATEDIF(A1,A2,"md")&" days"

--
Best Regards,

Luke M
"Maanu" wrote in message
...
Hi,

My DOB is 2-Feb-1970.. I want to know my age on 1-Jan-2010 in Years,Months
and days for Eg: 10 Years,9 months and 10 days.

How can I do this in Excel?

I took the difference by putting the two dates in two cells and took the
difference. But it is not working,

Thanks!

Date Difference
 

hi
="My Age now is "&DATEDIF(A1,TODAY(),"y")&" Years,
"&DATEDIF(A1,TODAY(),"ym")&" Months and "&DATEDIF(A1,TODAY(),"md")&" Days"

the above formula is all 1 line.

Regards
FSt1

"Maanu" wrote:

Hi,

My DOB is 2-Feb-1970.. I want to know my age on 1-Jan-2010 in Years,Months
and days for Eg: 10 Years,9 months and 10 days.

How can I do this in Excel?

I took the difference by putting the two dates in two cells and took the
difference. But it is not working,

Thanks!