Future date function

frob

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

John_Foster

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

frob

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

John_Foster

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.

John_Foster

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

https://app.smartsheet.com/b/publish?EQBCT=4681e37590ab4b9e8251951da93211ce

Thanks,

John

frob

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