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 .

Excel Formula to Find Differences in Numbers. ... For example, if you input "=NETWORKDAYS(B2,A2)" in a new blank cell, your result will include only the days between Monday and Friday.