Hello Sir,
Thanks a million for helping me out on this thread. However, I have one more question today in connection to the same spreadsheet.
In column "H", cumulative Totals keep on updating itself automatically using Sumif function from another sheet. Thus the Paid and Unpaid Status keeps on changing periodically. Example: Customer total amount recieved increases by the invoice amount thus in return marking it as "PAID" Therefore, my question to you is, if my cell changes to Paid, can there be a function to print the static DATE in column M whenever the cells in column G goes "PAID".. Automatically and i'd know later next days which one was Paid on what dates?..Thanks very much!!!