At 07:25 11/06/2010 -0500, Vic Dura wrote:
According the OOo 3.2.0 (WinXP) Help:
=========
MONTHS
Calculates the difference in months between two dates.
Syntax
MONTHS(StartDate; EndDate; Type)
StartDate is the first date
EndDate is the second date
Type calculates the type of difference. Possible values include 0
(interval) and 1 (in calendar months).
=========
Could some kind soul explain the difference between "interval" and
"calendar" months? I don't know what the difference is.
A bit of experimentation suggests that the "interval" meaning counts
days and increases the count on the same date in the following
month. So in "interval" months there are zero months from today (12
June) until any date up to 11 July, but one month up to 12 July or
thereafter, and so on.
Conversely, the "calendar months" meaning takes account only of the
month of the date, not the day in that month, so there is one month
from any date in June to any in July. In particular, there are zero
months from today (12 June) until any date up to 30 June, but one
month up to 1 July or thereafter, and so on. The difference between
31 January and 1 February is one calendar month, even though it is
only one day, and that between 31 January and 1 March is two calendar
months, even though - at 29 days (except in a leap year) - it is
shorter than most actual months.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
