Calcukate no of months between dates

Hey guys,

I am stuck with a simple problem.

I need to get the total number of months between 2 dates.

I have attached my sample file.

I need to substract Range "E" and "N".


So far, I got

* number of years in Range "R"
* number of months in range "S"
* number of days in range "T"

I have added range "R" and "S" to get total number of months in range "AC"


However i am stuck with the days .



If the number of days (Range "T") is above 2 and equal to less than 17 then it must be considered half month
If the number of days (Range "T") is equal to greater than 18 than it must be considered 1 month


Thus,
for example
if number of days is 2, then its 0 months
if its 6 days then i consider it half month (0.5 month)
if its 19 days then i consider it 1 month



Anyone can help me please?

Its basically for calculating interest on morgages

hey Richard,

this works great for me.

thank you.


Also is there anyway to consider febuary month as 30 days ?

I want to consider all months as 30 days.

Is it possible to consider all the months as 30 days?

i charge customer interest on the basis of number of months.

if its below 18 days then i consider as half month and if above or equal to 18 days then 1 month.


So here is an example:

*Through the formulae which you provided me:

suppose a person morgages his gold to me on 23.02.2018 and comes to withdraw it on 11.03.2018

through your formulae i get it as 16 days ( which is half month)


* through considering all month as 30 days

Now same morgage would give me different result as I am considering all months as 30 days.

Through my way i get 18 days ( 24,25,26,27,28,29,30,1,2,3,4,5,6,7,8,9,10,11)


Through your formulae its 16 days (half month) and through mine its 18 days ( which is 1 month)


this is the problem which i am facing.

how do i deal with this??

please help me

hey richard,

i have worked out on this.

I used days360 function to get this.

i have attached the sample file.

range "q" is the number of months

range "t" is the number of days .


All i need is this :

If the number of days (Range "T") is above 2 and equal to less than 17 then it must be considered half month
If the number of days (Range "T") is equal to greater than 18 than it must be considered 1 month


could you please help me?

is it possible to edit the formulae which you provided to me earlier and use?