Hi All,

I am developinga spreadsheet where the user will enter the following data
for each entry which will accumulate in a table.

Start Date 15-Jan-07
End Date 22-Oct-07
Total days 281 (calculation)
Hire Payment per day 10,000
Total Hire Received 2,810,000 (calculation)
Payable every (Days) 15
Hire Paid in Advance (this could also be in arrears)

How can I develop a formula that will automatically calculate, in a
tabulated format going across in months, what is payable and what should be
allocated to each specific month.

Thank you and a Happy, Peaceful and Productive New Year to all of you/sgl