One way ..

Try this sample from my archives:
http://savefile.com/files/638334
Club_Membership_Fee_Apportionments_v3.xls
[Fee Apportionments by no. of days within the month]
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"D Pingger" wrote:
Help please.

I have two columns (B and C) of dates which represent start and end dates
and column A that has a numeric data. Columns D and on are months (Jan
through Dec). Is there a function that I can use that would spread the
numeric data from column A in the months in columns D and on that B and C
represents?

TIA

D Pingger