Hi,
I have some raw data from an application, that has the date as follows:
108130
where 1 is century: that is, 21st century
where 08 is the year: that is, 2008
where 130 is the day in the given year: that is, May 9th
I am trying to find out how to convert 108130 to a date in excel
like:
5/9/2008
If anyone has ideas on this, it would be greatly appreciated.
Thanks,
Jeff
I have some raw data from an application, that has the date as follows:
108130
where 1 is century: that is, 21st century
where 08 is the year: that is, 2008
where 130 is the day in the given year: that is, May 9th
I am trying to find out how to convert 108130 to a date in excel
like:
5/9/2008
If anyone has ideas on this, it would be greatly appreciated.
Thanks,
Jeff