Forum Discussion
Conversion from European Date Format
I'm using Excel 365. I just copied a column of dates from a web page and pasted them into a column in Excel. The dates on the web page were in the European date format (i.e., dd/mm/yyyy). When pas...
Hi barshfield ,
See if this helps.
=DATE(VALUE(RIGHT(A2,4)), VALUE(MID(A2,4,2)), VALUE(LEFT(A2,2)))
This is assuming the "European" date is in Cell A2
See my Christmas example below.
Ben
- THANK YOU! I've been struggling for the past few days and after trying the above method, it worked. I can now move onto conditional formatting.
