Let's say I have two columns in a SharePoint list:

[Invoice Age] - text (20, 23, 25)

[Payment Status] - text (Not Paid, Paid)

I'd like to create a calculated column [Invoice Age] that will increase by 1 everyday assuming the [Payment Status] for that row is not updated to a specific value like "Paid." If the [Payment Status] for that row is updated to "Paid" then the [Invoice Age] will reset to 0 and increase by 1.

For example, a row with a [Invoice Age] of 15 will increase by 1 daily. So, tomorrow the column will reflect 16 and so on until the [Payment Status] is changed to "Paid" upon which the [Invoice Age] will go back to 0.

I don't know how complicated the above ask is but any insight/guidance will be appreciated.