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, I was hoping to get some help with this situation, where I am trying to take a list to list mapping on the left and get an output similar to the right, but the main idea is i want to be able to make the selected item (format: list), the dimension of a target module and reverse map the original source list as a list…
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New → New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, no…
Why in my model output is blank, after send explainability data.
