Counting number of years from date to today

**profitdr123** · 02-13-2015, 01:24 AM

I have a data base with the date owners bought houses (6/1/88) and I am looking for a formula that will calculate how many years, months, days from that date to today. How do I do that?

**FDibbins** · 02-13-2015, 01:30 AM

	A	B	C
1	6/1/1988	2/13/2015	26 years 8 months 12 days

C1=IF(DATEDIF(A1,B1,"y")=0,"",DATEDIF(A1,B1,"y")&" years ")&IF(DATEDIF(A1,B1,"ym")=0,"",DATEDIF(A1,B1,"ym")&" months ")&DATEDIF(A1,B1,"md")&" days"

**azumi** · 02-13-2015, 02:27 AM

Assumed your date in A1:

Put this on B1:

=TRIM(IF(INT((TODAY()-A1)/365,25)=0,"",INT((TODAY()-A1)/365,25)&" Years")&" "&IF(INT(MOD((TODAY()-A1)/365,25,1)*12)=0,"",INT(MOD((TODAY()-A1)/365,25,1)*12)&" Months")&" "&IF(INT(MOD((TODAY()-A1)/30,44,1)*30,44)=0,"",INT(MOD((TODAY()-A1)/30,44,1)*30,44)&" Days"))

**FDibbins** · 02-13-2015, 02:42 AM

Looking at azumi's post reminded me that I wanted to add...
if you dont want to put =TODAY() in its own cell, you could include it into my formula like this...
=IF(DATEDIF(A1,TODAY(),"y")=0,"",DATEDIF(A1,TODAY(),"y")&" years ")&IF(DATEDIF(A1,TODAY(),"ym")=0,"",DATEDIF(A1,TODAY(),"ym")&" months ")&DATEDIF(A1,TODAY(),"md")&" days"

(if you have a LOT of dates to check, it would be better to have it in it's own cell, then reference it)