Livin404
Active Member
 Joined
 Jan 7, 2019
 Messages
 393
 Office Version

 365
 2019
 Platform

 Windows
Greetings, I managed to get the proper five digit Julian Dates for Columns E & G both beginning on Row 2. I know the formula
does work, but I'm going to need the days difference, which I already have, but I just need the conversion and the Calendar dates displayed to make it more understandable for the reader.
Thank you,
Excel Formula:
=DATE(IF(0+(LEFT(E2,2))<30,2000,1900)+LEFT(E2,2),1,RIGHT(E2,3))
Thank you,