Calculating Birthday list with birthdays before 1900

BBro35 

=DATEDIF(IF(ISTEXT(A1),LEFT(A1,LEN(A1)-4)&IF(A2="v",-1,1)*RIGHT(A1,4)*1+4000,A1),IF(ISTEXT(B1),LEFT(B1,LEN(B1)-4)&RIGHT(B1,4)*1+4000,IF(ISTEXT(A1),DATE(YEAR(B1)+4000,MONTH(B1),DAY(B1)),B1)),"Y")&" Years, "&DATEDIF(IF(ISTEXT(A1),LEFT(A1,LEN(A1)-4)&IF(A2="v",-1,1)*RIGHT(A1,4)*1+4000,A1),IF(ISTEXT(B1),LEFT(B1,LEN(B1)-4)&RIGHT(B1,4)*1+4000,IF(ISTEXT(A1),DATE(YEAR(B1)+4000,MONTH(B1),DAY(B1)),B1)),"Ym")&" Months, "&DATEDIF(IF(ISTEXT(A1),LEFT(A1,LEN(A1)-4)&IF(A2="v",-1,1)*RIGHT(A1,4)*1+4000,A1),IF(ISTEXT(B1),LEFT(B1,LEN(B1)-4)&RIGHT(B1,4)*1+4000,IF(ISTEXT(A1),DATE(YEAR(B1)+4000,MONTH(B1),DAY(B1)),B1)),"md")&" Days"

Contains array formula: Do not enter border { }, but close the formula with CTRL+SHIFT+RETURN

Awkward but effective:)

Hope I was able to help you with this info.

NikolinoDE

I know I don't know anything (Socrates)

Was the answer useful? Mark them as helpful!

This will help all forum participants.