How do I change this to count days
 

I recieved help yesterday on my "IF" problem but I forgot the fact that if a
pymt is paid a month later it isn't calculating. Here is what I got
yesterday for a fix late fee;

=IF(OR(B7="",DAY(B7)=27),43.75,0)

Column A has date pymt due
Column B has date pymt paid
Column F has the late fee


Here is what a friend and I came up with for a per day late fee

=IF((B18-A18)=5,E18*0.05+(B18-A18-5)*E18*0.01,0)

The problem is again is that I need both formulas to reconize complete dates.

Example,

Column A - Date payment is due is 3-22-08
Column B - Date payment is made is 5-20-08

Thank you for your time and assistance.

How do I change this to count days
 

Make it easy. If you want to find number of days late, then do:

=(If(payment date - due date)0,(payment date - due date)*per-day charge,0)

Sounds like maybe you charge different late fees based on length of time
late? If so, just add that as a nested if.

"H Halliburton" wrote:

I recieved help yesterday on my "IF" problem but I forgot the fact that if a
pymt is paid a month later it isn't calculating. Here is what I got
yesterday for a fix late fee;

=IF(OR(B7="",DAY(B7)=27),43.75,0)

Column A has date pymt due
Column B has date pymt paid
Column F has the late fee


Here is what a friend and I came up with for a per day late fee

=IF((B18-A18)=5,E18*0.05+(B18-A18-5)*E18*0.01,0)

The problem is again is that I need both formulas to reconize complete dates.

Example,

Column A - Date payment is due is 3-22-08
Column B - Date payment is made is 5-20-08

Thank you for your time and assistance.