Why not just work in days - there is no ambiguity there !

If you take it that there are 365.25 days in a year on average, then
dividing this by 12 will give you 30.4375 as an average number of days
in a month.

If you make use of the DATEDIF function, I'm not sure what algorithm
it uses.

Hope this helps.

Pete

On Feb 1, 12:50*pm, catrrmg wrote:
Hi again! It just got slightly more complicated (or at least for me). Here is
an example to get the problem more clear: Mister X worked for a couple of
periods in our company:
start date * * * * * * * * * * * *end date * * * * * * * * * * *years * months *days
19.12.2003 * * *13.09.2005 * * *1 * * * 8 * * * 25
09.10.2005 * * *01.11.2006 * * *1 * * * 0 * * * 23
09.11.2006 * * *20.01.2008 * * *1 * * * 2 * * * 11
total * * * * * * * * * * * * * * * * * * * * * 3 * * * 10 * * *59
As we see it the ex the # of days corresponds to more than a month. The
question is: how do I convert if it is necessary the # of days in months,
months years, taking into consideration that a month could be 28, 29, 30
and 31 days long.
Thanks very much in advance.