How to calculate year/month/day's to date

[jodieduncan]

hello there

I am hoping someone can help.

I am currently doing a Personell spreadsheet.

I have in colum C5 the date the employee started. In column D5 I am looking for a formula that will show, year month and days to date they have worked for the company.

Can anyone help?

Thank you

[TheExcelphile]

Try this formula:

=IF(YEAR(TODAY()-C5)=1900,0,YEAR(TODAY()-C5)) & " years, " & MONTH(TODAY()-C5) & " months, " & DAY(TODAY()-C5) &" days"

Don't forget to click on the little star to the left of this post if you feel I helped!

[jodieduncan]

Hi thank you this

I have put it in but there seems to be an issue on the years its coming up with 4 figure numbers :S

[TheExcelphile]

OK, here is a modified version...

=YEAR(TODAY()-C5)-1900 & " years, " & MONTH(TODAY()-C5) & " months, " & DAY(TODAY()-C5) &" days"

I think that should work out now.

Don't forget to click on the little star to the left of this post if you feel I helped!

[mrjinx007]

Try this; is not most accurate but it wii do the job:
=(D5-C5)/365.25

[Teethless mama]

=DATEDIF(C5,TODAY(),"y")&" years, "&DATEDIF(C5,TODAY(),"ym")&" months, "&DATEDIF(C5,TODAY(),"md")&" days"