Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation for Dates
I'm sending out montly rent bills.
They contain a 5% late payment penalty if the rent is received after the 5th of the month. I'd love to setup up in excell a cell with the correct formula for a "late payment fee". The spreadsheet contains a cell "RENT" where the rent is listed. During the 3rd or 4th week of the current month, and it varies as to exact date, the bills are mailed out for the upcoming month. Any help would be appreciated. Bernie |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation for Dates
Since you don't say anthing about where the information is to make the
determination: Assume the payment date of last month is in C4, the Due date is in B4 the rent is in A1 the formula in D5 (this month's rent amount) =if(C4-B45,1.05*$A$1,$A$1) Regards, Tom Ogilvy Larry Moskowitz wrote in message om... I'm sending out montly rent bills. They contain a 5% late payment penalty if the rent is received after the 5th of the month. I'd love to setup up in excell a cell with the correct formula for a "late payment fee". The spreadsheet contains a cell "RENT" where the rent is listed. During the 3rd or 4th week of the current month, and it varies as to exact date, the bills are mailed out for the upcoming month. Any help would be appreciated. Bernie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculation of future value between two dates | Excel Discussion (Misc queries) | |||
Calculation Between 2 Dates | Excel Worksheet Functions | |||
Calculation with dates | Excel Worksheet Functions | |||
Calculation between two dates | Excel Worksheet Functions | |||
calculation sundays between two dates | Excel Discussion (Misc queries) |