MrExcel.com - Your One Stop for Excel Tips & Solutions

Calculate Invoice Due Dates

June 24, 2022 - by

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.

With a date and payments terms, you want to calculate a due date.
Figure 538. 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.

With Invoice Date in B2 and Terms in C2, use =B2+C2 to calculate Due Date.
Figure 539. Add a date and a number and you get a date.

This article is an excerpt from Power Excel With MrExcel

Title photo by Crissy Jarvis on Unsplash