Excel: Calculate Invoice Due Dates

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Problem: I have a spreadsheet of payables. I need to sort by Due Date, but all I have is invoice date and terms.

  1. 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.

  2. Add a date and a number and you get a date.