Hello all,
Where I work we use a slightly different version of the Julian Calendar. We have the first 3 digits as the day, the fourth digit is the year, and the last digit is the Production Line the work was produced on. Can anyone show me a formula for converting this into a regular DD/MM/Year format?
For example:
The first 3 numbers are the Julian day, the fourth number is the year (5=2015) and the last number is the Production Line
22358 - Produced on day 12/8/2015 on Line 8.
Consequently the Julian date would sometimes have a 0 in front of it, so would the format of the column need to be something special, or can the formula take into account leading zero's?
Thanks in advance!
Bookmarks