Memo MS Excel

=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))

Utilităţi