Months in a year based on number of days

**managingcrap** · 10-23-2014, 09:07 AM

I'm trying to figure out a function that converts number of days into number of months.

I attached the sample. I didn't get to the number of months just the number of days. I want the result to be as exact as possible.

I first thought of averaging 365 days and the 12 months and use the value output as denominator for the number days. There might be another way but I don't know what it is.

The data is only for date range for 2014, but the data can be (for example) from 03-01-2012 to 06-20-2014.

Thank you.

**Ron Coderre** · 10-23-2014, 09:16 AM

Using your posted workbook...
this regular formula returns the number of full months in the referenced date range

A3: =DATEDIF(B3,C3+1,"M")

In your example, 01-Mar-2014 to 15-Jul-2014 is 4 full months.

Does that help?
(BTW, if you're attaching a workbook with Calculation set to Manual...it would be nice if you warned us. :\)

**managingcrap** · 10-23-2014, 09:45 AM

On the specific example you just stated, the answer should be around 4.5 because March to June is 4 and July 1-15 is half.

Thanks.

**Ron Coderre** · 10-23-2014, 09:56 AM

Try this formula:
A3: =DATEDIF(B3,C3+1,"M")+DAY(C3)/DAY(EOMONTH(C3,0))

For 01-Mar-2014 through 15-Jul-2014 that formula returns: 4.48387096774194
The fraction is 15/31_days_in_July

Is that something you can work with?

**managingcrap** · 10-23-2014, 10:11 AM

Yes, Sir. Thanks

**Ron Coderre** · 10-23-2014, 10:58 AM

Glad you got something you can use!

If that resolves your issue, please take a moment to mark this thread as SOLVED (from the Thread Tools menu)

Months in a year based on number of days

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Months in a year based on number of days

Re: Months in a year based on number of days

Re: Months in a year based on number of days

Re: Months in a year based on number of days

Re: Months in a year based on number of days

Re: Months in a year based on number of days

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to transform a number in year/months/days

calculate number of days and splitting the it based on the year of the start and end date

[SOLVED] Number of days based on 365 day year

Days into Months/Year

i have two days and i want the difference in days, months, year

Bookmarks

Bookmarks

Posting Permissions