Converting dates to years, months & days

G

Guest

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.
 
C

Claud Balls

Do you want the result to be something like:
You are:
2 years old
24 months old
728 days old

or do you want something like:
You are:
1 year
11 months
23 days
old
 

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

Top