Hi

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

--
Regards

Roger Govier


"curtev" wrote in message
...
Greetings, I have dates in text, 19960320 (yyyymmdd) that need to be
converted to Julian date. Can this be done without first converting
to date
format? Thanks