Match Date Ranges - Return Value

[pw034]

I need to find a way to match a start date/end date then return a valu
for the matched dates.

Example....

In column E I have contract start date in mm-yy format. In column F
have contract duration (12,24,36). In column G I have contract en
date in mm-yy format. Column G has contract amount, and column I ha
total contract/contract months.

Then I have column T through column DA with dates from Jan-03 t
Dec-10.

All column headers start on row 4, data starts on row 5.

E4(Contract Start).....F4(Contract Duration)....G4(Contrac
End)....H4(Gross Contract $)....I4(Monthl
$)...J4(Jan-03)...K4(Feb-03)...and so on
E5(Mar-04)...............F5(12).........................G5(Mar-05)............H5($12,083)................I5(1,007)

Is there a formula that I can use that will match the start date i
column E with the date header in columns J-DA, and then the end date i
column G, and then place the amount in column I for the duration?

If the dates do not match, then it would just place a zero in tha
column. I am looking for a formula that would say something like if

E5<=J4,I5 but E5>=P5,0

I hope this makes sense. I am just looking to match dates in a range.
If the date fits, then return the value in column I, if not, the
returns a zero. In the end, I want to total column J-DA and in anothe
sheet, have the data placed in a grid for each calendar year broken ou
by month.

Thanks for any assistance you can offer

Pau

 

[Frank Kabel]

Hi
how do you want to match the dates as you only have months in these
columns? also how is then a non-match defined?

 

[pw034]

Matching month/year....date format is actually 3/31/03, but need t
match month/yea

 

[Frank Kabel]

Hi
if you liek email me an example sheet and I'll insert some example
formulas
email: frank[dot]kabel[at]freenet[dot]de

 

[pw034]

I found the formula that worked. I used an IF(AND(.... with <=,>
formula that did the trick.

Thanks again for your willingness to help!

Pau