IF formula on SharePoint Server - Syntax Error

Question

Here's what I entered but it still came up with the same error message. Just FYI - It is not the 365 version yet, we are still using the older version.

Answer 1

I have tested with the exact same formula and it works as expected. Here is the formula I test with and the outcome:

=IF(TODAY()-[Initial Conversation Date]>365,"NA",TODAY()-[Initial Conversation Date])  

Please check as following to narrow down this issue:

1. If you have set Initial Conversation Date column to format as Date & Time, switch to Date Only.
2. Create another calculated column in list/library and insert the formula I provide above.
3. Switch to Single line of text for the data type and see the result.
4. Do you have any setting in this list/library that worth attention? You can test in another list/library and see if you can reproduce this issue.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Answer 2

Try it without equal (=) sign in front of the formula. I had this issue a few times.