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.