Previous Topic Next Topic

Excel formula using Julian calendar

Closed
judy - Oct 6, 2015 at 03:38 PM
rizvisa1 Posts 4478 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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response