Date between date range
 

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.

Date between date range
 

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

On Jan 20, 11:55*pm, AJ wrote:
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.

Date between date range
 

Something like this:

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

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


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=52666