I created a calculated column and enter this formula:
=DATEDIF([Column 1],[Column 2],"d")
I picked the columns from the list to the right of the formula block. When I entered this, it gave an error that the
syntax wasn't correct. Also when I went to the column, it showed
#Name as the value.
Also, I have it selected as a number column as output. One last thing, when I click ok and go back to the formula, it removes the bracket from one of the columns, i.e.
=DATEDIF(Column 1,[Column 2],"d").
Not sure what I am doing wrong. This is for SharePoint 2013.