Looks very similar to another topic calculating days between two dates (in this case it should be months + pro rated to come up with the dynamic duratio ). I guess this is the trickiest part in the above: Working with two dates - show amounts between two selected dates - #4 by sam.mckay