Julian Date to Short Date

Jeff_Berman ✭✭✭✭
edited 12/21/22 in Formulas and Functions

I am trying to write a formula to convert a Julian date to a short date. This formula isn't getting the job done. Any recommendations would greatly be appreciated.

*note - this formula does work in excel

Julie Date Column:


Short Date Column (text/number type and date type were tried)

=IF(0 + (LEFT([Process Julian Date]@row, 2)) < 30, 2000, 1900) + LEFT([Process Julian Date]@row, 2), 1, RIGHT([Process Julian Date]@row, 3)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!