Excel provides built-in tools to help you to find discrepancies like Filters, Conditional Formatting, advanced functions (If and IS, VLookUp, etc.), and Add-ins.

Excel will calculate the number of days between the dates entered in cells B3 and A3 and display the result in cell C3. Take your mouse pointer to the lower-right corner of cell C3.