Date Formula

Contributor

Date Formula

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!

Message 1 of 3
2 REPLIES 2
Community Boss

Re: Date Formula

@sarah.esguerra 

 

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

Message 2 of 3
Contributor

Re: Date Formula

Thank you so much Rob!
Message 3 of 3