nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to calculate the difference for each month of the time period?

KubotaNatsuki

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

Accepted answers

AntonMineev

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

Снимок экрана 2021-04-09 в 09.32.54.png

Снимок_экрана_2021-04-09_в_09_104682.png

All comments

AntonMineev

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

Снимок экрана 2021-04-09 в 09.32.54.png

Снимок_экрана_2021-04-09_в_09_104682.png

KubotaNatsuki

Thank you for your reply!
I need to change it to date type.
I am going to use it as an example!
Thank you!!

VincentAbadie

@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

ChrisAHeathcote

=DATEDIF is not an Anaplan function!

Quick Links

Can you help?

Unanswered questions

Uploaded Date data in other formats
I am trying upload data from a CSV with date. For size reasons, I don't want to dimension the module by date but bring it in as a line item formatted as date. The problem is that person that will be doing the upload is in Italy, and their date format is different. When she does the upload, the date gets messed up…
Anaplan Level 3 Assign accounts to territory
Hi, when I am assigning the account to the territory I am always facing error as below and account never get assigned to the territory , what could be the reason ? When I use same method for unassign it works .
An Update on Anaplan Audit Log Reporting: A No-Code Approach
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…