Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difference betwen Excel Date () Function and System Date | Excel Worksheet Functions | |||
Difference System date and Excel Date function | Excel Worksheet Functions | |||
Difference between last date of month and given date | Excel Worksheet Functions | |||
Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
Date difference | Excel Worksheet Functions |