I need help with the following formula.
Colum C3 contains the month end date
Column A6 Contains a code
Column H6 contains the start date
Column I6 contains the end date
Colum J6 contains a value.

I have the formula
=IF(AND(I6<$C$3,A6<207003),($C$3-I6)/(I6-H6)*J6,($C$3-I6-($C$3-I6)/7)*2)

I need to alter the formula so that if the end date is less than the month
end date then no value will show.
Thanks