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

KubotaNatsuki
Contributor

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

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

KubotaNatsuki_0-1617947759080.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
AntonMineev
Regular Contributor

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

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.33.06.png

View solution in original post

4 REPLIES 4
AntonMineev
Regular Contributor

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

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.33.06.png

View solution in original post

KubotaNatsuki
Contributor

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

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
New Contributor

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


@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

KubotaNatsuki_0-1617947759080.png

 

 


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

ChrisHeathcote
Community Boss

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

=DATEDIF is not an Anaplan function!
Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA