I have a different date format(YYYY.MM.DD and MM/DD/YYYY) in my date column in Excel. As a final result, I want one date format ie MM/DD/YYYY. What is the easiest way to achieve it?
Here is an image of my data.on Right-click and Format cell it looks like the below.
The final output I want to like is this. I have tried the Text to Columns option as well but it didn't work.
With data in A2, in B2 enter:
and apply your format to B2.
Then copy B2 downward:
The formula converts any text values in column A into true Excel dates in column B.
Excel’s Format Cells function can quickly ...READ MORE
I suppose Excel has handled December 21 ...READ MORE
You can use dates in any computation ...READ MORE
The SUBSTITUTE() method can be used to ...READ MORE
To calculate the date difference, we can ...READ MORE
You can enter the following formula in ...READ MORE
Assuming the first date in A2 try this formula ...READ MORE
The number of days to take into ...READ MORE
This equation is completely adjustable. Your two ...READ MORE
Excel Tips, Learn Excel \ Raghu R
Setting ...READ MORE
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.