View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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