Hi,

I am trying to join 2 IF statements together and my patience is growing thin with this one. If you want to duplicate my efforts:

C13 - effective date

C18 - 1st month of 12 months, i.e. 1/1/03 (term will almost never be a calendar year)

D13 - value if true

"-" - value if false

1st statement

=IF(((MONTH($C13)/12)+YEAR($C13))<=((MONTH($C$18)/12)+YEAR($C$18)),$D13,"-")

B13 - end date

B18 - last month of 12 months, i.e. 12/31/03 (term will almost never be a calendar year)

D13 - value if true

"-" - value if false

2nd statement

=IF(((MONTH($B13)/12)+YEAR($B13))<=((MONTH($B$18)/12)+YEAR($B$18)),$D13,"-")

I am trying to automatically calculate 12 months (each in its own cell) based on the 'start date' and 'end date'.

For the 2nd months formula: add +1

=IF(((MONTH($C13)/12)+YEAR($C13))<=((MONTH($C$18)+1)/12)+YEAR($C$18)),$D13,"-")

3rd month add +2 and so on.

If ANYONE gets what the heck I am babbling about, I would appreciate the help!

thanks,

kt