Calculation for Dates

[Larry Moskowitz]

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

 

[Tom Ogilvy]

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-B4>5,1.05*$A$1,$A$1)

Regards,
Tom Ogilvy