Date between date range

[AJ]

I am trying to compare a date for an invoice to see if it falls between a
date range and then I want it to return a value.

For example
Column A Column B Column C
10/4/2008 11/2/2008 Oct 2008
11/3/2008 12/1/2008 Nov 2008
12/2/2008 01/03/2009 Dec 2008

If I have a date of 10/28/2008 in another field, I would like for it to
search to see what date range (between column A and B) it would match and
then return the value from column C. There will be multiple dates that I
will need to check.

 

[Pete_UK]

Suppose your date is in D1. Then in E1 you can use this:

=VLOOKUP(D1,A$1:C$20,3)

Copy it down as required.

Hope this helps.

Pete

 

[JBeaucaire]

Something like this

=SUMPRODUCT(--(A1:A3<=G1),--(B1:B3>G1),--(C1:C3)

And be sure to format the results cell as Custom: MMM YYY