Ok.
I read your formula.
There is a mistake on it.
Please, pay attention at a DAY part of it.
My suggestion:... DAY(MID(A1,3,3))
Your Formula:..... DAY(MID(A1,3,
4))
Correct the formula and try again.
I hope it will work after it.
--
Belo Horizonte,
Brasil.
Marcílio Lobão
I changed the formula to =DATE(20&LEFT(A1,2),MONTH(MID(A1,3,3)),DAY(MID(A1,3,4))) and this worked for only one date 7/22/2015, but I need it for all of the dates in the Julian calendar. If you can figure out anything that works I would appreciate it. I will try on my end, also.
Thank you very much for your help.