CRUTHERFORD
Board Regular
- Joined
- Jul 10, 2014
- Messages
- 107
Hi,
So i am trying to compose an excel formula that will do the following...
example:
Cell A1 = 15th March 2014
Name of Columns B = Bookeddate
Cells b1, b2, b3 etc all contain a bookeddate.
Name of Columns C = DepartureDate
Cells c1, c2, c3 etc all contain a DepartureDate
Is there a formula that can tell me whether the date in cell A1 falls between any of the dates in cells B1 + C1 or B2 + C2 or B3 +C3 etc as a range ?
Thanks,
Cam
So i am trying to compose an excel formula that will do the following...
example:
Cell A1 = 15th March 2014
Name of Columns B = Bookeddate
Cells b1, b2, b3 etc all contain a bookeddate.
Name of Columns C = DepartureDate
Cells c1, c2, c3 etc all contain a DepartureDate
Is there a formula that can tell me whether the date in cell A1 falls between any of the dates in cells B1 + C1 or B2 + C2 or B3 +C3 etc as a range ?
Thanks,
Cam