Cobol date to standard excel date
Posted on 2014-02-06
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.