79166576

Date: 2024-11-07 13:09:54
Score: 3
Natty:
Report link

=DATE(VALUE(RIGHT(C2,4)),VALUE(LEFT(C2,FIND("/",C2)-1)),VALUE(MID(C2,FIND("/",C2,1)+1,FIND("/",C2,FIND("/",C2,1)+1)-FIND("/",C2,1)-1)))

WHERE C2 is your input date cell

Reasons:
  • Low length (1):
  • No code block (0.5):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: Sanjay