Showing posts with label Date. Show all posts
Showing posts with label Date. Show all posts

Wednesday, October 2, 2024

Contatenate text to Date to Sort

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

at No comments:
Labels: , , , ,
Subscribe to: Posts (Atom)

How to select all blank cells in a range to keep unlocked in excel.

  Select Only the Blank Cells: Press Ctrl + G (or F5 ) to open the Go To dialog box. Click the Special... button at the bottom left. Sele...

  • install PowerMTA on the server
    We can install PowerMTA on the server. rpm -ivh /home/PowerMTA-4.0r6.x86_64.rpm You will see the output like this Preparing... #############...
  • Remove Autodesk software from Mac
      Uninstall products using the Remove utility For some products, you can run the Remove  ProductName  utility in the Finder > Go > App...
  • MacPro M1 Monterey Xforce Keygen not opening
    Instructions: Copy xf-adesk19 to your Desktop Open terminal  (Command+Space and type Terminal and press enter/return key) Paste the followin...