Another common calculation is to calculate the difference between two dates such as date received or date started and the actual completion date.
Even though the entry is formatted as a date, these types of date calculations work because every date in Excel has a numeric value behind it starting with 1 at the beginning of the year 1900 and it grows incrementally every day. What if we have a deadline of 30 days for the completion of a process? You could simply add 30 to the date started or the date received. Let’s look at how to create Excel date calculations with these functions. How can you calculate the difference between two dates in Excel? And what if you also want to create calculations with dates and exclude weekends and possibly holidays? Let’s look at two Excel functions, WORKDAY and NETWORKDAYS, that will help you to create calculations with dates that only include working or business days. By Dawn Bjork, MCT, MOSM | The Software Pro ®
