Assistance finding a particular date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I need some help to determine if a date (26/4/04) falls in between a spreadsheet containing the start and end dates as shown below in my example. Thanks, Stev

First Day Return Dat
15/04/2004 30/04/200
27/03/2004 27/04/200
19/04/2004 27/04/200
23/04/2004 27/04/200
13/04/2004 27/04/200
19/04/2004 26/04/200
22/04/2004 26/04/200
20/04/2004 22/04/200
13/04/2004 21/04/200
19/04/2004 20/04/200
6/04/2004 20/04/200
13/04/2004 20/04/200
 
Hi
one way (if C1 contains your specific date, col. A the first day and
col. B the return day
=IF(SUMPRODUCT((A1:A100<=C1)*(B1:B100>=C1))>0,"within your ranges","out
of ranges")
 
Back
Top