C1=DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1)) =DATE(YEAR(D2),MONTH(D2)+E2,DAY(D2)) =DATE(RIGHT(A5,4),--LEFT(A5,1),--MID(A5,FIND("/",A5)+1,2))