How to calculate the date given the year and yearday?

Options

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?

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!