Hi. I'm trying to automatically fill in a late fee on payment sheet.
There is a date in A1 of 1/10/08. The actual date that a payment was posted is in A12 as 1/21/08. A late fee is assessed after 15 days.
So I'm trying to get an IF statement to work that subtracts A12-A1 then if the difference is greater than 15 adds the late fee, if not value is 0.
Thanks, Ray.
Bookmarks