compare dates using a variable
How do you define intersect?
Based on your sample they never intersect. The closest they come is:
From the start date: 12/13/2008
From the future date: 12/10/2008
--
Biff
Microsoft Excel MVP
"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
|