Need to calculate late charge from date cell

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I need to create a formula that will allow me to calculate a late charge if the customer is late. I have the =TODAY() calculation in Cell A4. I want the spreadsheet to automatically calculate the late charge if I receive a payment late by one day. The payments are supposed to be received on the 1st of every month and on the 2nd a late charge is assessed. If the payment is collected on the 1st, nothing should happen or even just a $0.00. Does this make sense?

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
If you are basing your calculations of late charge based on Today(), you are losing money as every day you open the workbook, the cell would have that days value


Since I have no idea how your data look like, I can only give you the formula that will let you know the first of the current month

=DATE(YEAR(TODAY()), MONTH(TODAY()), 1)