1 problem - month still left

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)