$100.00 on the 6th of the month and $3 a day

[Jesssharonxo]

How can i format a late fee column in excel. I need it to be able to have a $100.00 late fee on the 6th of every month and then an increase of $3.00 everyday until it is paid.

[Richard Buttrey]

Hi and welcome to the forum

With the Date Due in A1 and the date paid in B1 (blank if not paid) then in C1

=IF(AND(B1="",TODAY()>EOMONTH(A1,0)+6),130+(TODAY()-(EOMONTH(A1,0)+6))*3,"")

[Jesssharonxo]

SO where would i be posting that formula at? i formatted it to match my excel "IF(AND(G4="",TODAY()>EOMONTH(B4,0)+6),130+(TODAY()-(EOMONTH(B4,0)+6))*3,"")" correct?

[Jesssharonxo]

Its not working, unless i am doing something wrong

[Richard Buttrey]

Upload the workbook you're using if you can't map your Date due to the A1 cell and the Date Paid to B1 that I used in the formula.

It doesn't matter where you put the formula as long as you use the correct cell references in the formula

i.e. is your G4 the Date paid (or blank) and B4 the date due?