Are these TEXT entries?

They are date entries mm/yy

I'm also assuming that the date interval does not span into a new year?

They do span into a new year.

What should happen when the amount is not evenly divisable by the number of
months?

3 to 4 place decimals should be sufficient.

TIA

D Pingger



"T. Valko" wrote:

What should happen when the amount is not evenly divisable by the number of
months? For example:

Amount = 1
Start date = 1/1/2007
End Date = 3/1/2007

One month has to be 0.34 and the other two would need to be 0.33.

Columns D and on are months (Jan through Dec).

Are these TEXT entries?

I'm also assuming that the date interval does not span into a new year? For
example:

Start date = 6/1/2007
End date = 2/1/2008

--
Biff
Microsoft Excel MVP


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