Date Formula

SarahE

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!

rob_marshall

@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,

 

Rob

SarahE

Thank you so much Rob!