• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Date formats

M

Mandar

New Member
Please help me with date format, I'm importing a data from diffrent software and pasting it on excel sheet. The date format in that software is dd/mm/yyyy whereas in excel it is mm/dd/yyyy.


Please advise on how to homogenies the date formats. As date is an critical field for entire analysis. Can a macro code can help in this?
 
First, let's do a Text-to-Columns to split the numbers out. Use Delimited, with "/" as the character to deliminate on.

You should now have 3 columns. We'll rebuild the date into correct date using this formula:

=DATE(C2,B2,A2)


Voila! All your dates should now be corrected.
 
You must log in or register to reply here.
Back
Top