Calculate the difference between two dates

Applies to: Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007. Use the DATEDIF function for calculating the difference between two dates. Begin by entering a start date in a cell, and an end date in a different cell. Then enter a formula like one of the following. Warning: If the Start_date is larger than theContinue reading “Calculate the difference between two dates”

SUM Function – Overview

This function simply adds values; whether single, cell references/ranges or a combination of all three. For example: =SUM(B2+B3+B4+B5) – Adds each individual cell from B2 to B5. =SUM(B2:B5) – Adds the values in the cell range of B2:B5. Syntax: SUM(number1,[number2],…) Argument name Description number1   Required The first number you want to insert. The number can beContinue reading “SUM Function – Overview”