Inside Microsoft Excel

Calculate the number of days between two dates using Excel’s DAYS function

Inside Microsoft Excel

by Julie Duncan

When you need to know how much time has elapsed between two dates, Excel 2013 provides a straightforward solution: the DAYS function. For example, if you have a list of outstanding invoices and would like to encourage your customers to pay them, you can use DAYS to determine how far past due each invoice is, or the age of each invoice. This calculation helps you decide which action to take.

We’ll calculate the[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)