Excel has a number of formulas that enable you to count the time between two dates. You can specify that you would like to count the difference in hours by adding a time specifier to your formula or ...

In this post, we will show you how to count colored cells in Microsoft Excel. While working with Excel, we often color-code cells to distinguish them from the rest of the data. This is good because ...

Finding the exact difference between two dates in Excel may not be the most used feature, but it can be a lot of fun. A classic example is working out someone’s age. It’s not as complicated as it ...

An Excel spreadsheet can become an indispensable tool for your business when you harness its power for keeping records and doing computations. Take advantage of the program's seemingly limitless ...

Counting duplicate values is a subject that begs definition. What constitutes a duplicate? Within Excel, you can have duplicate values within the same column or you can have duplicate records — a row ...

In this post, we will show you how to calculate the expiry date in Microsoft Excel. Calculating expiry dates is a common requirement when working with Excel, especially for tracking inventory, ...

If you are using Microsoft Excel to manage numerical data, at some point you're inevitably going to display percentages. Doing so can give you a new insight, or make summarizing heaps of data a bit ...