• Excel Book Excerpt

Excel Calculate Invoice Due Dates

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

Calculate Invoice Due Dates

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

LE10000557.jpg 

Figure 546 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.

LE10000558.jpg 

Figure 547 Add a date and a number and you get a date.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel: