Memo MS Excel Ovidiu.S 14/01/2023 Extragere data nasterii din CNP Visual Basic =DATE(IF(OR(LEFT(B4,1)="5",LEFT(B4,1)="6"),"20"&MID(B4,2,2), "19"&MID(B4,2,2)),MID(B4,4,2),MID(B4,6,2)) 1 =DATE(IF(OR(LEFT(B4,1)="5",LEFT(B4,1)="6"),"20"&MID(B4,2,2), "19"&MID(B4,2,2)),MID(B4,4,2),MID(B4,6,2)) Partajează asta:TwitterFacebook