Future date function

✭✭

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)))

• ✭✭✭✭✭✭

Hi @frob,

This formula should do the trick.

=IF([Test Date]@row > DATE(IF(MONTH(TODAY()) = 11, YEAR(TODAY()) + 1, IF(MONTH(TODAY()) = 12, YEAR(TODAY()) + 1, YEAR())), IF(MONTH(TODAY()) = 11, 1, IF(MONTH(TODAY()) = 12, 2, MONTH(TODAY()) + 2)), DAY(TODAY())), 1, 0)

Hope it helps!

John

• ✭✭

Unfortunately, that did not work. My Feb due dates are still showing as false.

• ✭✭✭✭✭✭

Hi @frob,

That's odd, I tested it on a February date and it shows as ticked in mine. I am using a 1 or 0 rather than True or False though.

• ✭✭✭✭✭✭

Hi @frob,

Please find below a link to my sheet with the working formula, feel free to take a look and see if it helps

Thanks,

John

• ✭✭

Got it to work. There was just one true false statement that was off. Thank you for all the help!!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!