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

• ✭✭✭✭✭✭
Options

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

• ✭✭
Options

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

• ✭✭✭✭✭✭
Options

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.

• ✭✭✭✭✭✭
Options

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

• ✭✭
Options

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!