Compare two dates and convert to age

[PRodgers]

I am trying to compare the difference between to dates (a person dob and the date of an activity they have carried out and then output the age of the person when this activity was done:

for example:

activity date: 08/01/2008
dob: 05/12/2007

I want to output the person age in months and years, can anyone help?

[NBVC]

Try Datedif()

=Datedif(A1,B1,"y")&" years "&Datedif(A1,B1,"ym")&" months"

[arthurbr]

Does this help?

=DATEDIF(BirthDate,activitydate,"y")&" years "&DATEDIF(BirthDate,activitydate,"ym")&" months "&DATEDIF(BirthDate,activitydate,"md")&" days"

[arthurbr]

Damn, the Lone ranger's dad beat me at it !

[PRodgers]

Thanks guys, appreciate that, it worked brilliantly both ways.

[NBVC]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[PRodgers]

Guys im having trouble with a couple of dates:

activity date: 19/06/08
DOB: 26/11/02

Im getting "#VALUE!" in the cell:

formula: =DATEDIF(I4,J4,"y")&" years "&DATEDIF(I4,J4,"ym")&" months"

[NBVC]

Are those dates entered per your regional settings?

Ie, maybe they should be month/day/year?

Also, DOB should be in I4 and activity date in J4

[PRodgers]

Are those dates entered per your regional settings?

Ie, maybe they should be month/day/year?

Also, DOB should be in I4 and activity date in J4

Hey,

Yeah they are regional, i have the date formatted as day/month/year, i have 150 rows of dates.

[NBVC]

Try selecting the column, go to Data|Text to Columns... skip to 3rd window and select Date from the Column Data format area... then select DMY from drop down next to the DATE

Click Finish

[PRodgers]

Try selecting the column, go to Data|Text to Columns... skip to 3rd window and select Date from the Column Data format area... then select DMY from drop down next to the DATE

Click Finish

hey, i changed the date format to dmy format, i still cant get the second row to calculate the years and months between the dates:

dob = 26/11/02

activity = 19/06/08

I get #value in the row.


The first row works with the date:

dob = 12/05/07
activity = 08/01/08

this outputs 0 years 7 months

[NBVC]

Can you post a sample workbook (no confidential data)

[PRodgers]

Sample workbook:

[NBVC]

Like I had guessed, your dates in column A were not actually dates...

I did what I had said using the TextToColumns and now get results as attached.

[PRodgers]

Like I had guessed, your dates in column A were not actually dates...

I did what I had said using the TextToColumns and now get results as attached.

NBVC thankyou very much for your help, i really appreciate it