Here is the case -

StartDate EndDate Total amount January February March ......
01/27/2007 06/30/2007 $1,875.00
01/01/2007 08/07/2007 $2,195.00
02/10/2007 05/01/2007 $1,500.00

How to calculate amounts for each month ?

ye mula purush, tyo lekhekko pada na yar. ######### ayo bhane tyo cell ma right click garera format ma number select gara ( fomat ma date, scentific, etc huncha).
Maile mathi bhanya k ta ? " For the date cell, click format and click date. For amount , click format and click number. "

But mine method is different than Bond. My method includes exact no. of days for all the starting date to ending date ( whether its 1 or 2 or 25)

if you see 1/1/1900..
all u need to do is
1. Rt Click
2. Format cells
3. select General (it will be date by default what why it showed that 1/1/1900)
hope this helps!

I tried ... but got values in decimals ... something really fishy going on!

1875.00 2,195.00 1500.00 Monthly

JAN 60.48 31.00 10.02 310.71 371.19
FEB 338.71 28.00 10.02 280.64 19.00 18.52 351.85 971.20
MAR 375.00 31.00 10.02 310.71 31.00 18.52 574.07 1259.78
APR 362.90 30.00 10.02 300.68 30.00 18.52 555.56 1219.14
MAY 375.00 31.00 10.02 310.71 1.00 18.52 18.52 704.23
JUN 362.90 30.00 10.02 300.68 0.00 663.59
JUL 31.00 10.02 310.71 0.00 310.71
AUG 7.00 10.02 70.16 0.00 70.16
219.00 81.00 5570.00

Who ever you have asked this simple question must be a smarty A .....H..... because you gave your homework to us. You should have uesed a calculator and a calender and got the answer.

Any way here is my math for you.

Months 1875.00 2,195.00 1500.00 5570.00
JAN 60.48 310.71 371.19
FEB 338.71 280.64 351.85 971.20
MAR 375.00 310.71 574.07 1259.78
APR 362.90 300.68 555.56 1219.14
MAY 375.00 310.71 18.52 704.23
JUN 362.90 300.68 - 663.59
JUL -00 310.71 00- 310.71
AUG -00 70.16 00- 70.16
- - - 5570.00

I think it is clearer now.

1875.00 2,195.00 1500.00 5570.00

JAN 60.48 310.71 00.00 371.19
FEB 338.71 280.64 351.85 971.20
MAR 375.00 310.71 574.07 1259.78
APR 362.90 300.68 555.56 1219.14
MAY 375.00 310.71 18.52 704.23
JUN 362.90 300.68 - 00.00 663.59
JUL - 00 310.71 00- 310.71
AUG -00 70.16 00- 70.16
Total 5,570.00

haha .... if I try to do this by using a fking calculator and a fking calendar, it will take me fking years coz the data I have posted above is just a preface of a mahabharat.

thank you!

I love you all.

does our solution work?
Is this what u were looking for?