How do I get the AR Invoice Age formula to stop aging when invoice has been paid?

JYR

I starting to create a AR sheet.

I used the formula =Today()-(Invoice Date Sent)@row - which does show the age. However when the Invoice is paid what formula or rule condition do i use to make it stop aging?

Neil Watson

I would introduce 2 columns, a checkbox to indicate payment status, and a date column with the payment date.

Then amend the invoice age formula as =IF([Payment Status]@row = "0", NETDAYS([Invoice AGE]@row, TODAY()), NETDAYS([Invoice Date Sent]@row, [Date Closed]@row))

I might have the start and end date for NETDAYS switched around but you get the idea.