ExcelBanter - Julian dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Julian dates (https://www.excelbanter.com/excel-programming/356990-julian-dates.html)

Lara

Julian dates

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?

Carim

Julian dates

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

All times are GMT +1. The time now is 12:06 AM.