Need to calculate late charge from date cell Closed

Question

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?

rizvisa1 · Answer

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)

Need to calculate late charge from date cell

1 response

Similar discussions

Subscribe To Our Newsletter!