Convert 01.01.2024 to 01/01/2024 to count as date in Excel.
=DATE(RIGHT(A2,4),MID(A2,FIND(".",A2,1)+1,FIND(".",A2,FIND(".",A2,1)+1)-FIND(".",A2,1)-1),MID(A2,1,FIND(".",A2,1)))
Showing posts with label Concatenation. Show all posts
Showing posts with label Concatenation. Show all posts
Wednesday, October 2, 2024
Subscribe to:
Posts (Atom)