Excel formula using Julian calendar

Closed
judy - Oct 6, 2015 at 03:38 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Oct 6, 2015 at 04:01 PM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Oct 6, 2015 at 04:01 PM
"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
0