knightly, many thanks for your response. the first approach reducing
value to monthly one is useful and I will incorporate.

the second approach is great also and I will be tweaking it for use
with the other calcuations that I have to make. thank you again for
such a clear answer.


--
vgreen
------------------------------------------------------------------------
vgreen's Profile: http://www.excelforum.com/member.php...o&userid=26510
View this thread: http://www.excelforum.com/showthread...hreadid=397768