To find the percentage difference between two sets of data in Excel, you can use the aforementioned guide. In other words, it is possible to calculate it by using a formula like this: = (B2/A2)-1.

Either way, counting the number of records that fall between two dates is easy using the COUNTIFS () function (which isn’t available in Excel 2003 or earlier).

A formula in Excel always begins with an equal sign (=), indicating to Excel that the following expression is intended for calculation. For instance, if you want to sum the values in two cells ...