S

#### spence

plan dates. It's working perfectly for what I need except that in some

instances there will be no value in cell B3 (a date). I need to figure out

how to rework things so that if B3 is blank the calculations in my IF

statements will still occur and I'm in over my head. Any assistance is

appreciated.

Thanks,

spence

=IF(AND($B$3>$N$1,$B$1>$N$1,$B$4>$N$2),$B$5*(($M$2/12)*((YEAR($B$2)-YEAR($L$2))*12+MONTH($B$2)-MONTH($L$2)+1)+1),IF(AND($B$3<$L$1,$B$1<$L$1,$B$4<$L$2),$B$5*(($M$1/12)*((YEAR($B$2)-YEAR($L$1))*12+MONTH($B$2)-MONTH($L$1)+1)+1),IF(AND($B$3<$L$1,$B$1<$L$1,$B$4>$N$2),$B$5*(($M$1/12)*((YEAR($B$2)-YEAR($L$1))*12+MONTH($B$2)-MONTH($L$1)+1)+1)*(($M$2/12)*((YEAR($B$2)-YEAR($L$2))*12+MONTH($B$2)-MONTH($L$2)+1)+1),$B$5)))