Hi Fred,

Thanks for the quick response. I have tried out the example you
provided but it doesn’t seem to account for the fact that the Jan
financial month ends on 27th Jan and not the 31st. So the number of
Days revenue in month one should be 1000 / 33 * 22 Days, then month two
should be 1000 / 33 * 9 Days.

It all sounds too hard doesn’t it!

Kind Regards
Garry


--
Gazzr
------------------------------------------------------------------------
Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075
View this thread: http://www.excelforum.com/showthread...hreadid=507492