Calculated column based on another calculated column

0
votes

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!

1
sharepointsharepoint-list

1 Answers

0
votes

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")