hi!
I'm not good at English.
I want to calculate the difference for each month of the time period.Is it possible to get the duration of a month when the format is a time period?
Thank you.
Image diagram
Hi @KubotaNatsuki!
I'm not very good with English either, but I hope my options will help you 🙂
I have figured out several formulas over time that may help you (see attachments
@KubotaNatsuki wrote: hi! I'm not good at English.I want to calculate the difference for each month of the time period.Is it possible to get the duration of a month when the format is a time period?Thank you. Image diagram
In a new cell, type in =DATEDIF(A1,B1,”Y”). The “Y” signifies that you'd like the information reported in years. This will give you the number of years between the two dates. To find the number of months or days between two dates, type into a new cell: =DATEDIF(A1,B1,”M”) for months or =DATEDIF(A1,B1,”D”) for days.
Official Website
Hi experts: I put all the values into the formula, I think it should return TRUE, not FALSE, but why it return me FALSE? Maybe I missed something here ? Thank you for the help!
Has anyone gotten an error like this when you have SSO and you are trying to use the Excel plug in? We have some users that get the screen below but some don't. We have checked that all users have the same version of Excel. Weird part about the screen below is it actually says the connection was successful.
Hello everyone, We are trying to use Anaplan Connect in order to push data from a dwh to Anaplan Data Hub. To do so, we need an authentication by token. We can't make it work, we receive the following error: ERROR 16020 |-- Anaplan API: Invalid key path Any suggestions? Thank you all in advance for the help! Michele
