Date between date range

A

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.
 
P

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top