On Nov 14, 5:30 pm, jland wrote:
How do I find the exact years and days between 2 dates?
Use DATEDIF. Example assumes the two dates are in C28 and D28:
=DATEDIF(MIN(C28,D28),MAX(C28,D28),"y")&" years,
"&DATEDIF(MIN(C28,D28),MAX(C28,D28),"md")&" days"
Use this formula if you want the days to be inclusive:
=DATEDIF(MIN(C28,D28),MAX(C28,D28),"y")&" years,
"&DATEDIF(MIN(C28,D28),MAX(C28,D28),"md")+1&" days"
Here's a reference:
http://www.cpearson.com/excel/datedif.aspx