Future date function

Options

Hello,

I'm trying to create a true statement if the due date is 2 months in the future. I have tried to formula below but it's not working. Any suggestions?

=IFERROR(IF([Due Date]@row > DATE(YEAR([Due Date]@row), MONTH(TODAY() + 1), DAY([Due Date]@row)), true, false), (IF([Due Date]@row > DATE(YEAR([Due Date]@row), MONTH(TODAY() - 11), DAY([Due Date]@row)), true, false)))


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!