This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
We have a base that we use for our accounts receivable process. We created a column that calculates how many days old the invoice is with the following formula: DATETIME_DIFF(TODAY(),{Date of Delivery},‘days’) . This takes today and subtracts the day...
Here is a screenshot of the base. The column with the pink hue in the background is the formula showing how many days old, and each set is grouped by company. You can see the company on top has an invoice 133 days out, the next company has 11 days, ...
