Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting dates to years, months & days
How do I change the difference between a past date & todays date to years,
months & days? I want to have a column that shows how old someone is in yrs, months & days from the birthdate of the individual to todays date. I have two columns with dates - 1 for the birthdate and 1 for todays date. I take the difference of the two then I convert to years, months & days but how? I converted to years OK, but I am having a problem with converting to months & days. Thanks for any help on this subject. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting dates to years, months & days
Do you want the result to be something like:
You a 2 years old 24 months old 728 days old or do you want something like: You a 1 year 11 months 23 days old *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting days to years & months & days | Excel Discussion (Misc queries) | |||
Problem With Converting Days Months And Years | Excel Discussion (Misc queries) | |||
problem of converting days months and years | Excel Worksheet Functions | |||
Probem Of Converting Days Months And Years | Excel Discussion (Misc queries) | |||
Converting number of days to years and months | Excel Worksheet Functions |