If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Minus Dates
I have dates in Range("A2:A20") like see below
01/04/2009 05/04/2009 06/04/2009 10/04/2009 11/05/2009 etc……… And again I got date in cell B2 and in cell C2 and I want formula in cell D2 which should return the number of days between the dates which I have in cell B2 and C2 excluding the days for which I have dates in Range("A2:A20"). For example at the moment I got date "31/03/2009" in cell B2 and date "10/04/2009" in cell C2 and I got formula "=C2-B2" in cell D2 which return the result 10 days. But I want formula somthing like "=C2-B2-any date in range("A2:A20") equal to or more than B2- any date in range("A2:A20") equal to or less than C2", in other words i want to exclud the days for which i have dates in Range("A2:A20") from the formula which i have in D2. I hope i was able to explain my question. Please can any friend have any suggestion or solution for what i should be doing. |
#2
|
|||
|
|||
Minus Dates
See your other post in programming.
-- Jim Cone Portland, Oregon USA |
Thread Tools | |
Display Modes | |
|
|