projectile
Board Regular
- Joined
- Dec 14, 2007
- Messages
- 193
Hi,
I have a date range on sheet 1
ie. Cell A1 is 01/10/2011 and Cell B1 is 07/10/2011
I have a list of dates on sheet 2 ranging from A1:A100
I want to return a date or dates from that list in sheet 2 if it falls within the two dates on sheet 1.
Sounds simple enough but is proving to be difficult as the examples ive seen online use index which requires specifying a date im looking for; I do not want to specify a date I simply want the dates to be shown which meet the criteria.
Thanks
I have a date range on sheet 1
ie. Cell A1 is 01/10/2011 and Cell B1 is 07/10/2011
I have a list of dates on sheet 2 ranging from A1:A100
I want to return a date or dates from that list in sheet 2 if it falls within the two dates on sheet 1.
Sounds simple enough but is proving to be difficult as the examples ive seen online use index which requires specifying a date im looking for; I do not want to specify a date I simply want the dates to be shown which meet the criteria.
Thanks