Number to installments between two dates

[b96392]

Hi,

I am trying to calculate the number of installments paid between two dates.
In the sheet added to this thread I have tried to give an example of what I mean.

Lets say they signed the deal 08.08.2010 and todays date is 05.09.2011. Then I want a cell to calculate how many 6 months periodes has gone by in the periode.

Thank you.

[inayat]

Hi,

I think you want the formula in G2 instead of F2.

Formula in G2

Please Login or Register  to view this content.

What I have done is calculated the no. of months and then divided it by 6. You need to be precise when the installments are going to be paid so that we can modify it accordingly.

[b96392]

Dateif is not possible to use in my excel version (2007). The installments are going to be paid +6 months after the signing date.

Thank you.

[Marcol]

DATEDIF() is an unsupported formula, but it is still available in 2007 and later.
See this link
The DATEDIF Worksheet Function

[daddylonglegs]

DATEDIF is in Excel 2007 - it can be a difficult function to find, it's not in the function list or in the help files [edit as Marcol says...]......but you can use it by just typing the formula in or copying and pasting from here

I think you can use the formula that inayat suggests, but wrapped in INT to get a whole number, i.e.

=INT(DATEDIF(E2,F2,"m")/6)

[b96392]

Well, it sure does not work in my excel 2007 version
I have tried them all and all with the same result- no result (errors). :\

[daddylonglegs]

OK, you might need semi-colons in the formula rather than commas for your regional settings....does this work?

=INT(DATEDIF(E2;F2;"m")/6)

[Marcol]

Are you using Excel with the formulae displayed in Norwegian?

It might possibly be that because DATEDIFF is unsupported the formula doesn't convert from English.

Try this workbook

[b96392]

Thank you all! It works:-)