Date Formula



I need to get the number of days spent to finish a task.

What I have is "Date Start" and "Date End", currently, in excel its a simple Date End minus Date Start and it will give the number of days spent.

I tried to convert date to text or number, but it doesn't convert it that way.


How can I do this in Anaplan?


Big thanks!

Best Answer

  • @SarahE 


    In Anaplan, it is actually easier than Excel in that you can just subtract the Start Date from End Date which will give you the Days Spent.




    Hope this helps,