Julian dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How does one convert dates that were entered in a date data type format then
erroneously turned to Julian format by copying them into a general or text
data type feild back to the correct date format?
 
Hi Lara,

Following formula should do the job :
=DATE(IF(0+(LEFT(A1,2))<30,2000,1900)+LEFT(A1,2),1,RIGHT(A1,3))

HTH
Cheers
Carim
 
Back
Top