PrevContributor

Re: Any equivalent to the Excel TODAY() function in Anaplan??

PrevContributor

February 2016

[quote=Dino Sanchez]Has anyone figured out how to do this? I currentyl am doing work for a client and they need to count their daily interest rate versus their maturity date. Still have not figured o…

1

Re: How to get COUNTIF type of formula in Anaplan

PrevContributor

January 2016

[quote=Dino Sanchez]I was looking to count a list property text and come up with a numerical value total. In excel we can use countif, what can i use here in Anaplan?[/quote] The method Devin has giv…

1

Re: COUNTIF Type of Function in Anaplan?

PrevContributor

March 2016

Thank you Kelly!

1

Re: How to Calculate Months Difference between Two Dates

PrevContributor

May 2016

Thanks Emily for the fast response. I ended up using (End Date - Start Date) / 365 * 12. This will give the highest degree of accuracy.

1

Re: Referencing Switchover Period

PrevContributor

November 2016

Hi Ramu, what if you have multiple versions, each with different switchover dates? In this case, what would be the way to reference the switchover period of each version? Kind regards, Marcel

1