Hello!
Creating a sheet to help with Accounts Payable process to external providers.
External providers will submit their invoice and payment details into a form that feeds into this sheet.
Would like the formula to determine when that invoice is set to be paid, depending on the submission date.
The formula in words..
If Submit Date is on or before the 20th of current month, Set Payment Due to last day of current month.
But if Submit Date is after the 20th current month, set Payment Due to the last day of next month.
(Submit Date is the auto generated field of "Create Date")
😀