Excel formula using Julian calendar

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

Can someone please help me create a formula in excel to convert A16612009 to 6/15/2015. The letter A stands for the year 2015, 166 stands for June 15. The rest of the numbers are relevant. I would greatly appreciate your help.

Thank you,
Judy



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
"A" part does not seem to make sense. the best i can think that a refers to current calendar year. Also what happens if days are less than 100

any ways based on what you gave this is what you can try
=DATE(YEAR(NOW()),1,1)+MID("A16612009',2,3) -1