Date Formula

SarahE
SarahE
in Modeling

Hi,

 

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!

Tagged:

Best Answer

  • rob_marshall
    rob_marshall
    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.

     

    2019-01-28_21-53-59.png

     

    Hope this helps,

     

    Rob

Answers

Categories