Search code examples
sharepointsharepoint-list

Calculated column based on another calculated column

In a sharepoint list I have one Number column named "DAYS" and onther calculated column named "TAKEN" with the formula (=DATEDIF[StartDate],[EndDate],"d")). I need to substract from "DAYS" the result from the calculated column "TAKEN" but it gives me an error.

``` =[DAYS]-DATEDIF([StartDate];[EndDate];"d") ``

I bet is really simple but driving me crazy. Thanks for the help!

Solution

  • Could be the semicolons. You use semicolons or commas depending on cultural settings.

    Try:

      =[DAYS]-DATEDIF([StartDate];[EndDate];"d")

    Or:

      =[DAYS]-DATEDIF([StartDate],[EndDate],"d")