Innovation Technology
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)))
Steps: Apply your filter in Sheet1 . Select the range where you want to paste the formula (e.g., A2:A100 ) but only visible cells will...
No comments:
Post a Comment