Return a value if the date lands between a row of dates

**treyes** · 06-30-2011, 03:23 PM

How to return a value if the date displayed land between a row of dates? Example

B1: Date: 6/10/2011

Row 3: has dates on a quarterly basis (6/30/2011,9/30,2011, etc)

Cell B2 displays value.

see attached

**tigeravatar** · 06-30-2011, 05:55 PM

treyes,

In your attachment, there's nothing in B1 or B2. What value are you looking to have returned?

~tigeravatar

**treyes** · 06-30-2011, 06:00 PM

Thank you tiger,

Excuse the confusion. I'm looking to have returned the values that are in cell E5 if the Sale Date (cell D5) lands in between or on the quarterly end dates starting on rows F3:J3. I would like the values to be displayed in F5 thru J32.
Hopefully this makes sense.

Thanks again.

**tigeravatar** · 06-30-2011, 06:26 PM

treyes,

Attached is a modified version of your sample workbook. In cell F5 is the following formula:
=IF(AND($D5>E$3,$D5<=F$3),$E5,"-")

Then I copied over and down for each section

Hope that helps,
~tigeravatar