Hi all,
I have an SPO list that includes 4 columns: Review Frequency, Last Review Date, Next Review Date and Content Expiry Date.
The last Review Date is set manually.
The Review Frequency is either Annual or Triennial.
The Next Review Date needs to be set automatically based on the Review Frequency.
The Content Expiry Date needs to be set automatically to 3 months after the Next Review Date.
I know I can use a calculated column to populate the Content Expiry Date by using the formula below:
=DATE(YEAR([Next Review]),MONTH([Next Review])+3,DAY([Next Review]))
The Next Review Date I am struggling with. It needs to be 3 months less than 1 year if the Review Frequency is Annual or 3 months less than 3 years if the Review Frequency is Triennial. If anyone can help me with the syntax for the If statement I can use in another calculated column it would be amazing.
Thanks in advance
