I have upto 20 date ranges - the start date is in column A and the end date is in column B - EG
A B
1/1/13 10/1/13
1/2/13 1/2/13
3/3/13 6/3/13
I then have a list of dates in colum D - EG
1/1/13
2/1/13
3/1/13
4/1/13
all the way to end of year..
I want a formula that will return a "1" in the corresponding cell in column E if the date falls in any of the date ranges in columns A and B. For example 1/1/13 2/1/13 3/13/13 4/1/13 etc would all have a 1 next to them because they fall in the range 1/1/13 to 10/1/13. Is this possible?
I'd really appreciate any answers given. Thanks in advance.
Bookmarks