Excel 2013 Tutorial - How to Convert Standart Date to Julian Date Formats
JULIAN dates are often used in manufactures environments as a time stamps on a quick reference for a batch number.
In this tutorial you will learn how to convert standard dates to Julian dates.
=RIGHT (YEAR (B5), 2) -- extracts the right two digit of the year number.
=B5-DATE (YEAR (B5), 1, 0) -- finds how many days have passed since the beginning of the year.