This should solve the negative month problem as well.

=YEAR(M2)-YEAR(M1)-IF(MONTH(M2)MONTH(M1),0,1) & " " &
(MONTH(M2)-MONTH(M1))-IF(DAY(M2)=DAY(M1),0,1)+IF(MONTH(M2)<=MONTH(M1),1 2,0)
& " " &
IF(DAY((DATE(YEAR(M1)+(YEAR(M2)-YEAR(M1)-IF(MONTH(M2)=MONTH(M1),0,1)),MONTH
(M1)+((MONTH(M2)-MONTH(M1))-IF(DAY(M2)=DAY(M1),0,1)+IF(MONTH(M2)<MONTH(M1),
12,0)),DAY(M1))))=DAY(M1),M2-(DATE(YEAR(M1)+(YEAR(M2)-YEAR(M1)-IF(MONTH(M2)
=MONTH(M1),0,1)),MONTH(M1)+((MONTH(M2)-MONTH(M1))-IF(DAY(M2)=DAY(M1),0,1)+I
F(MONTH(M2)<MONTH(M1),12,0)),DAY(M1))),DAY(DATE(YE AR(M1),MONTH(M1)+1,1)-1)-D
AY(M1)+DAY(M2))


- Mangesh




"Mangesh" wrote in message
...
=YEAR(A2)-YEAR(A1)-IF(MONTH(A2)=MONTH(A1),0,1) & " " &

(MONTH(A2)-MONTH(A1))-IF(DAY(A2)=DAY(A1),0,1)+IF(MONTH(A2)<MONTH(A1),12 ,0)
& " " &

IF(DAY((DATE(YEAR(A1)+(YEAR(A2)-YEAR(A1)-IF(MONTH(A2)=MONTH(A1),0,1)),MONTH

(A1)+((MONTH(A2)-MONTH(A1))-IF(DAY(A2)=DAY(A1),0,1)+IF(MONTH(A2)<MONTH(A1),

12,0)),DAY(A1))))=DAY(A1),A2-(DATE(YEAR(A1)+(YEAR(A2)-YEAR(A1)-IF(MONTH(A2)

=MONTH(A1),0,1)),MONTH(A1)+((MONTH(A2)-MONTH(A1))-IF(DAY(A2)=DAY(A1),0,1)+I

F(MONTH(A2)<MONTH(A1),12,0)),DAY(A1))),DAY(DATE(YE AR(A1),MONTH(A1)+1,1)-1)-D
AY(A1)+DAY(A2))

should solve that problem.

Mangesh




"JE McGimpsey" wrote in message
...
Hmmmm...

A1: 12/30/2004

A2: 3/1/2005 === 0 2 1

Add one day:

A2: 3/2/2005 === 0 2 0

Add another day:

A2: 3/3/2005 === 0 2 1

or

A2: 12/1/2005 === 1 -1 1





In article ,
"Mangesh" wrote:

=YEAR(A2)-YEAR(A1)-IF(MONTH(A2)=MONTH(A1),0,1) & " " &


(MONTH(A2)-MONTH(A1))-IF(DAY(A2)=DAY(A1),0,1)+IF(MONTH(A2)<MONTH(A1),12 ,0)
& " " &


A2-(DATE(YEAR(A1)+(YEAR(A2)-YEAR(A1)-IF(MONTH(A2)=MONTH(A1),0,1)),MONTH(A1)


+((MONTH(A2)-MONTH(A1))-IF(DAY(A2)=DAY(A1),0,1)+IF(MONTH(A2)<MONTH(A1),12 ,0


)),DAY(A1)))+IF(A2-(DATE(YEAR(A1)+(YEAR(A2)-YEAR(A1)-IF(MONTH(A2)=MONTH(A
1)


,0,1)),MONTH(A1)+((MONTH(A2)-MONTH(A1))-IF(DAY(A2)=DAY(A1),0,1)+IF(MONTH(A2


)<MONTH(A1),12,0)),DAY(A1)))<0,DAY(DATE(YEAR(A1)+( YEAR(A2)-YEAR(A1)-IF(MON
TH


(A2)=MONTH(A1),0,1)),MONTH(A1)+((MONTH(A2)-MONTH(A1))-IF(DAY(A2)=DAY(A1),0
,1)+IF(MONTH(A2)<MONTH(A1),12,0)),DAY(A1))),0)