Hi

If by intersect you mean that the resulting date is the same, then it
never will be with the example you posted.
With 10/May/2010 in A1 and 16/Jul/2007 in B1
=B1-A1 = 1029 days
=MOD(1029,6) =3
The dates can only be the same, in the case where MOD = 0.
i.e. there is no remainder when you divide the number of days difference
by 6.

The mid point will be
=(B1-A1)/2+A1
which is 11/Dec/2008 12:00

The nearest dates will be plus and minus 1.5 (half of the MOD value)
days from this date
="11/Dec/2008 12:00" -1.5 = 10/Dec/2008 00:00 and
="11/Dec/2008 12:00" +1.5 = 13/Dec/2008 00:00

--
Regards

Roger Govier


"old coach" wrote in message
...

i need to know when 2 dates intersect
1-i begin with todays date and add a variable to it
2-i then subtract the same variable from a future date
3-i need to know at what date the 2 intersect

example: 7-16-2007 + 6=7-22-2007 5-10-2010 - 6=5-4-2010
then: 7-22-2007 + 6=7-28-2007 5-4-2010 - 6=4-28-2010,
etc
this loop continues until they intersect.




--
old coach