MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Date Formula


Posted by Alison on July 19, 2001 8:35 AM

We have extracted some data from a database into excel and the date format is yyyy/mm/dd. Does anyone know a formula which we can use to change it to dd/mm/yy?

Thanks for your help in advance


Posted by Barrie Davidson on July 19, 2001 8:40 AM

Assuming your date is a number and is in cell A1, try this formula:

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

Barrie

Posted by Mark W. on July 19, 2001 8:41 AM

How is your data getting into Excel? Are you
using the Text to Columns wizard? Does your date
value currently reside in Excel as a text value?