Difficulty 2 of 5 · about 3 min
Work out an invoice due date with EDATE
Each invoice has an invoice date in column B and payment terms in whole months in column C. In D2, write ONE formula that fills D2:D5 with the due date for each invoice: the date that falls the number of months in column C after the invoice date in column B. When the due month is shorter than the invoice day, use the last day of that month. Leave D3:D5 empty. (Hint: EDATE only works on a whole range when wrapped in ARRAYFORMULA.)
Loading grid…