If the text "Start Date" is in A1 and the date is in B1, then in B3 use
=B2-B1
But this will work only if you have 'real' dates in B1 and B2. To test this
in C1 enter =B1+1 and you should get 16-Jan-07. If not you need to learn how
to enter dates and format them.
In B5 use =B3*B4 to get 2,810,000 - you may need to format the cells to get
the commas
Now you can copy the formulas across the worksheet by dragging the fill
handle - solid square in lower right corner of active cell

But wait! You do not want to see 'funny' stuff before dates are added to the
new columns.
In B3 =IF(B10,B2-B1),"") ... "" is a pair of double
quotes
In B5 =IF(B40,b3*4),"")
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"sgl" wrote in message
...
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