# Convert Duration to Numbers of Months

1. ## Convert Duration to Numbers of Months

Hi to all Experts,

i m wondering a formula which convert my duration i.e. number of days convert into number of months:

for example :

605 Days : after conversion of this it should appear like that
20 Months & sixteen days etc.

pls help me somebody....  Register To Reply

2. ## Re: Formaula for Convert Duration to Numbers of Months

But it's not same if you look for example:

100 days:

1.1.2011 - 10.04.2011 is 3 months and 10 days
20.1. 2011 - 29.4.2011 is how much? (Please enter some value)
1.2.2011 - 11.05.2011 is 3 months and 11 days

What you expect as result in those cases?  Register To Reply

3. ## Re: Formaula for Convert Duration to Numbers of Months

dear zobar,

u r correct ok but i need formula for that

bcz i want to count the number of months.

pls provide me any particular formula for that .

thanks.....  Register To Reply

4. ## Re: Formaula for Convert Duration to Numbers of Months

It's not problem but I'm asking you this because we need to know how to calculate it.

So we need to know what's your expected result.

here is simplier solution:

30 days

that can be:

0 month 30 days (for example January, number of month days is 31)
1 month 2 days (for example February, number of month days is 28).
1 month 0 days (for example March, number of month days is 30)

So, when you enter 30... What you expect to get as result?  Register To Reply

5. ## Re: Formaula for Convert Duration to Numbers of Months

Assuming you arrive at the number of days by subtracting two dates
Say in A2
16/10/2009
In B2
13/06/2011
Then
=B2-A2 returns 605

=DATEDIF(A2,B2,"m") ..... returns 19 (months)

=DATEDIF(A2,DATE(YEAR(B2),MONTH(B2)-DATEDIF(A2,B2,"m"),DAY(B2)),"d") ....returns 28 (days)

Concatenate these ``Please Login or Register  to view this content.``
This returns:= "19 Months & 28 days."

Hope this helps  Register To Reply

6. ## Re: Formaula for Convert Duration to Numbers of Months

Thanks Mr. Marcol for your clarification,

as u described that :

Say in A2
16/10/2009
In B2
13/06/2011
Then
=B2-A2 returns 605

upto here all picture are clear but while using formula DATEIF i m little bit confuse.

Which is that DATEIF is not any formula in excel & according to quoted some code by u tell me that how to apply this code in my work book through that i can execute that DATEIF formula & can get desired result.

thanks  Register To Reply

7. ## Re: Formaula for Convert Duration to Numbers of Months

thanks.............

thanks..................  Register To Reply

8. ## Re: Formaula for Convert Duration to Numbers of Months

See here for a full explanation of this undocumented function
Chip Pearson - The DATEDIF Worksheet Function  Register To Reply