How to convert US to UK dates
Category: [Excel] Demo Available
How to convert US to UK dates
Requirement:
To change US date format to UK date format.
Solution:
=IF(MID(A2,4,2)>=13,(MID(A2,4,2)&"/"&LEFT(A2,2)&"/"&RIGHT(A2,2))+0,IFERROR(MID(A2,4,2),A2))
Obtained from the OzGrid Help Forum.
Solution provided by MysticGenius.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to calculate duration difference between two dates |
| How to count non blanks 5 years from the last non blank date |
| How to use SUMPRODUCT with dates |
| How to set dynamic dates for pivot table grouping |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.