How to calculate the date given the year and yearday?


I basically want the inverse of YEARDAY(date) function.

If I have the 1-365 year day number and the year, is it possible to create a formula to result in the DATE?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!