Hello!
So I don't know the best way to explain this, but in my prepaid expenses worksheet for the company I work for, I have our invoice amount, the start and end date, and a formula to calculate the total amount of months to amortize (which is based off the
start and end date.) I then have a formula under each month that will amortize out the expense and when it is complete, it will just put - or $0 in the cell to show that the amortization is complete. Our company amortizes an expenses in the current month
if the start date is from the 1st to the 15th. If it is the 16th through the 31st, we start recognizing the expense or monthly amortization next month. The formula I have in the monthly cells does fine for most expenses but if the start and end date is
the 15th or 16th, it won't amortize the expense out for the correct amount of months. One expense I have, my month calculation calculated 3 months, but the formula recognizes the expense for 4 months. I can't figure out what to change within the monthly
formula I have to make these mid month (or around mid-month expenses) amortize out correctly. Thank you all for the help and I hope what I am saying makes sense! Here is the monthly formula I have that is calculating some expenses for a month extra. =IF(
AND($D9<=I$4, $E9>EOMONTH(I$4,-1)), $H9, 0)*IF(AND(DAY($D9)>15,OR(EOMONTH($D9,0)=I$4, EOMONTH($E9,0)=I$4)),0.5,1)

($D9 is the start date, I$4 is the current month, $E9 is the end date, and $H9 is the monthly amortization amount)

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)