Formating Dates

Closed

Cindy - Jul 26, 2016 at 11:30 AM
Blocked Profile - Jul 26, 2016 at 04:48 PM

Hello,

I am trying to do a VLookup between to spread sheets and having a terrible time with the dates formatting correctly. Each spread sheet comes from a different program and put into excel one file is opened with a delimited format and the other is not. My problem is on one spread sheet the date shows as 06/27/2013 and in the delimited spread sheet is shows as 20130627. Can you tell me how I can format these so when doing our compare this will work.
Thank you,

Formating Dates
Defcon dates - Guide
Vivatech 2024 dates - Guide
Different dates of "end to end encryption message" on blank chat? - Internet & Social Networks Forum
Gamescom dates - Guide
Encryption And Decryption - Download - Encryption and decryption

1 response

Answer 1 / 1

Blocked Profile
Jul 26, 2016 at 04:48 PM

You can use date along side with Left(), MID(), and RIGHT().

See below!

Similar discussions

encryption message several time in chat

blank white page for website

IF statements with dates and criteria

using web browser page loads but screen blank

Conditional Formatting - highlight overdue dates

Similar discussions

Subscribe To Our Newsletter!