Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
compare dates | Excel Worksheet Functions | |||
Compare two dates and if they are equal | Excel Discussion (Misc queries) | |||
how do I compare two dates? | Excel Worksheet Functions | |||
Variable dates on X axis evenly spaced (should not be) | Charts and Charting in Excel | |||
Compare range of dates and sum... | Excel Discussion (Misc queries) |