CONVERT NUMBER INTO DATE IN EXCEL

CONVERT NUMBER INTO DATE IN EXCEL

|| CONVERT NUMBER INTO DATE IN EXCEL  ||

this formula for dt 1 to 9:
=DATE(CONCATENATE(20,RIGHT(cell,2)),MID(cell,2,2),LEFT(cell,1))

this formula for dt 10 to 31:
=DATE(CONCATENATE(20,RIGHT(cell,2)),MID(cell,3,2),LEFT(cell,2))

#goole