I'm new to formulas and need some help. I have done a few little "If"
functions. I am trying to set up a spreadsheet for monthly prepaid
information. I have 12 month columns, beginning date, end date, # of months
and Total Invoice. I need a formula that I can input into the 12 monthly
columns where it will calculate the monthly prepaid amount for however many
months to be divded over, i.e. invoice for $2000 begin 1/1/2008, end
3/31/2008, 3 months so needs to only show in Jan, Feb and Mar. Maybe it
can't be done. I have input some formulas but it calculates out for all 12
months.
--
Phyllis J. Baynes