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.