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
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
Estimated Level of Effort: <4 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L1 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased response time to address risks Increased forecast accuracy You Might Also Like: * Tops-Down Allocations Historical Snapshotting One of…
