mobanker
asked on
Cobol date to standard excel date
I have a list of dates outputted from a COBOL program that are in this format:
Here is a date from the file = 0206139
That is 7 bytes, the first byte is zero. The next byte is 2, which means century ‘20’ . The next 2 bytes are ‘06’, that is the year. The next 3 bytes is the Julian day. ‘139’ is May 19th. So that date is 5/19/2006.
Can anyone help me make an excel formula to convert those dates for me? Any month, year, date combination would work for me.
Thank you
Here is a date from the file = 0206139
That is 7 bytes, the first byte is zero. The next byte is 2, which means century ‘20’ . The next 2 bytes are ‘06’, that is the year. The next 3 bytes is the Julian day. ‘139’ is May 19th. So that date is 5/19/2006.
Can anyone help me make an excel formula to convert those dates for me? Any month, year, date combination would work for me.
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for mobanker's comment #a39840444
for the following reason:
His answer matched my specifications quite well.
Accepted answer: 0 points for mobanker's comment #a39840444
for the following reason:
His answer matched my specifications quite well.
did you give barryhoudini the points for the answer?
ASKER
His answer was very close to my specifications and worked.
ASKER
Sorry for the slow response. My data happens to be only 2000 and later dates, so that is great. I tested the formula out, I had to remove the leading zero to make it work, but it got the job done and your date matched the example.
Thank you for your help - Great job!