Filter data in a range or table

Applies to: Excel for Office 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel Starter 2010. Use AutoFilter or automatic comparison operators including “greater than” and “top 10” in Excel to reveal your preferred data and conceal those left over. After you’ve filtered data in a range of cells or table, you can chooseContinue reading “Filter data in a range or table”

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”