Need assistance with IF then formula to return either biannual review date or annual date

RBenton

I am working on a formula for our policy management system. If the Review Frequency is biannual, the Next Review Date will automatically generate a date two years from the Published Date. If the Review Frequency is annual, the Next Review Date will automatically generate a date one year from the Published Date. Can someone please assist with this formula?

DKazatsky2

Hi @RBenton,

Give this a try.

=IF([Review Frequency]@row = "annual", DATE(YEAR([Published Date]@row) + 1, MONTH([Published Date]@row), DAY([Published Date]@row)), DATE(YEAR([Published Date]@row) + 2, MONTH([Published Date]@row), DAY([Published Date]@row)))

Hope this helps,

Dave

RBenton

Thank you for your response. This formula returned an error.

Paul Newcome

What error exactly are you getting?

This should also work:

=DATE(YEAR([Published Date]@row) + IF([Review Frequency]@row = "Annual", 1, 2), MONTH([Published Date]@row), DAY([Published Date]@row))