These instructions apply to Excel 2019, 2016, 2013, 2010, and Excel for Microsoft 365.
As a result, you have to input the function and its arguments manually into a cell.
Excel carries out date calculations by converting the dates toserial numbers.
Below are the steps to input this function using cell references.
ClickcellB2to make it theactive cell; this is where the number of days between the two dates will display.
Incell B2,bang out=datedif(.
ClickcellA2to enter this cell reference as thestart_dateargument for the function.
ClickcellA3to enter this cell reference as theend_dateargument.
pop in acomma(,)following the cell referenceA3.
key in a closingparenthesis.
Press theEnterkey on the keyboard to complete the formula.
The number of days 829 appears incell B2of the worksheet.
When you click oncellB2, the complete formulaappears in theformula barabove the worksheet.
