I need to create a calculated column in SharePoint with a text output but it includes a date+day equation. I am getting syntax error which I believe is due to the column wanting the output to be a date/time given the equation I entered. Is there a workaround for this issue?

Example Formula:

  • Hi, I tried same formula and it's work for me. =IF(StartDate<=(Date+65),"Compiance","Non-Compliance"). just me sure column name you specify on formula that exist on list. Commented Nov 7, 2019 at 4:59
  • Your column name is rly Compiance? Make sure that there is no spelling difference in code and column name -> Maybe your column name is Compliance
    – SteffPoint
    Commented Nov 7, 2019 at 6:25

3 Answers 3


Have you tried to make output a "Single Line of text"? Is [Date] a column in your list?

enter image description here

  • Yes to both the Single Line of Text and Date s a column in my list
    – Kristy
    Commented Nov 6, 2019 at 20:59

I use your calculated formula and the column works perfectly.

Whether Date and SignatureDate columns are "Date and Time" columns?

Please check if there is no spelling problem for column name and characters in your formula. And you can create same column in another list and check if the issue exists.


With a test list, the exact same syntax worked for me. Even worked with empty dates values. Maybe you need to analyze ULS log


enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.