The "DateDiff" function in Excel lets you display the difference between two dates. The difference can be in days, years or months. The result shows in the cell where you type the equation into the Excel spreadsheet, and is displayed in an integer format next to the dates you want to evaluate.
- Skill level:
Other People Are Reading
Click the Windows "Start" button and select "All Programs." Click "Microsoft Office," then click "Microsoft Excel" to start the program.
Press the "Ctrl" and "O" keys on the computer. In the opened dialogue window, double-click the file you want to edit. Click the cell where you want the results of the "DateDiff" function to appear.
Click the "Developer" ribbon tab at the top of the Excel window. Click the "Visual Basic" button to open the VBA editor. Double-click "Sheet1" to open the editor to the current sheet.
Type the following code in the editor:
Function GetDifference (myDate1 as Date, myDate2 as Date) as Long
GetDifference = DateDiff("d", myDate1, myDate2)
Click the "Save" button, then close the VBA editor. Type "=GetDifference(A2, A1)" and press "Enter." Replace "A2" and "A1" with the cells that contain the dates you want to compare. Excel calls the VBA function and displays the date difference in days.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for