Formula Help
 

I am trying if do an if statment that will enable me to search through
a data set and if it matches it will return with a value. The
following is what I am trying to do

Example A $200 start date 01/02/07

Data Set

01/01/07 - 01/31/07 -01/31/07
02/01/07 - 02/28/07 -02/28/07
03/01/07 - 03/31/07 -03/31/07

Solution: 01/02/07 is between 01/01/07 - 01/31/07 so it will give me
the value of 01/31/07.

Is there any way to have a formula do this. Also I would like to
extend my dates for a full fiscal year if any one knows how.

Formula Help
 

Hi:

If your dates are in distinct columns try:

=VLOOKUP(DATEVALUE("02/01/07"),A1:A3,1, TRUE )

otherwise try:
{=VLOOKUP(DATEVALUE("02/01/07"),DATEVALUE(LEFT(A1:A3,8)),1,TRUE)}

(this is a range formula so replace the {} with control enter).

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"KevinM" wrote:

I am trying if do an if statment that will enable me to search through
a data set and if it matches it will return with a value. The
following is what I am trying to do

Example A $200 start date 01/02/07

Data Set

01/01/07 - 01/31/07 -01/31/07
02/01/07 - 02/28/07 -02/28/07
03/01/07 - 03/31/07 -03/31/07

Solution: 01/02/07 is between 01/01/07 - 01/31/07 so it will give me
the value of 01/31/07.

Is there any way to have a formula do this. Also I would like to
extend my dates for a full fiscal year if any one knows how.