Problem: I have a spreadsheet of payables. I need to sort by Due Date, but all I have is invoice date and terms.
- Calculate the due date for each invoice.
Strategy: This one is simple for Excel. Simply add =B2+C2. You should get a date. If you get a number, then format the result as a date.
- Add a date and a number and you get a date.