Forum Discussion
Solved
Syntax error on calculated column formula - date
Trying to get this formula to work in SharePoint. What I am trying to achieve is a column that calculates the date based on the input on two columns. I got this to work, but when one of the column...
=IF(OR(ISBLANK([Review Date]),ISBLANK([Review Cycle])),"",DATE(YEAR([Review Date]),MONTH([Review Date])+[Review Cycle],DAY([Review Date])))
=IF(OR(ISBLANK([Review Date]),ISBLANK([Review Cycle])),"",DATE(YEAR([Review Date]),MONTH([Review Date])+[Review Cycle],DAY([Review Date])))