How do I write the following formula as a function that lets me supply any cell reference as cell1 to convert from text to a date?
=DATE(LEFT(cell1,4),LEFT(RIGHT(cell1,4),2),RIGHT(cell1,2))
Thanks in advance
=DATE(LEFT(cell1,4),LEFT(RIGHT(cell1,4),2),RIGHT(cell1,2))
Thanks in advance