Reply to message

Thank you for this. But my "K" is giving me #VALUE! error on all the cells with invoices. Please assist. What might be the cause. l tried changing the formats of "G" and "J" to numbers and dates again to no avail.