Im going to guess this is pretty easy stuff but cant figure out exactly how, or if, I can do this.Shared album - William McDonald - Google Photos


I have had no training in Excel just pretty much winging it and figuring it out as I go.

On my spreadsheet I was wondering if there is a way to have the LATE FEE column amount added onto the TOTAL DUE column only if the DATE PAID is 6th of the month or after? Does that make sense? Basically if someone pays rent the 6th or later it will automatically add the late fee to the to the total.


I appreciate any input and responses. Thanks so much.