This hidden gem, (available with Office Professional 2013, 2016, and Office 365 ProPlus) makes it easy to compare two workbooks, interactively. You can see how values, formulas, and formatting differ – line by line, and cell by cell, highlighting just the type of differences you specify.
To Use Spreadsheet Compare
Find and launch the app by clicking Start then typing ‘Spreadsheet Compare’.
Click Compare Files. The Compare Files dialog appears.
Click the folder icon to select the older and newer files, then click OK.
In honor of the 40th anniversary of J.K. Rowling’s seminal classic, Harry Potter, this post magically exposes a hidden excel function!
Ever wonder if your spreadsheet is keeping something from you?
DATEDIF is an under-documented function. It allows you to calculate the difference between two dates. Although it doesn’t appear in the Function Wizard (it exists to insure backward compatibility with Lotus and earlier Excel versions) it is a powerhouse when it comes to calculating date differences.
Using DATEDIF function:
Format: =DATEDIF ( date1, date2, “interval”)
date1must be the earlier of the two dates or an #NUM error is returned.