With your date in cell A1
=DATE(VALUE(LEFT(A1, 4)), VALUE(MID(A1, 5, 2)), VALUE(RIGHT(A1, 2)))
--
HTH...

Jim Thomlinson


"NervousFred" wrote:

I have a date in a table that is in the format 20080620. (Year Month Day all
together). Is it possbile to make execl convert this into a format I could
use in the DAY360 function?

Thanks!