### calculate number of months in a period using months

Posted:

**Mon May 19, 2008 9:04 pm**try to use MONTHS to calculate the number of months in a period (several years)

-what method should i use to write the date? dd-mm-yyyy? or mm-dd.yyyy?

- whatever I do the answer is 1 or -1 or 0 (if not code 504)

Question: does MONTHS calculate the number of months in a given period of time? What should I do to get a result?

(I did use the formula wizzard)

greetings from Cicade

-what method should i use to write the date? dd-mm-yyyy? or mm-dd.yyyy?

- whatever I do the answer is 1 or -1 or 0 (if not code 504)

Question: does MONTHS calculate the number of months in a given period of time? What should I do to get a result?

(I did use the formula wizzard)

greetings from Cicade