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 ...

Microsoft Excel allows you to crunch massive quantities of data easily through the use of functions. Sometimes you need to know the number of actual data points without counting blank cells. As an ...

Excel's COUNT function produces a number of cells containing any value, but only COUNTIF and COUNTIFS can use conditions to ...

Q. Is there a quick way in Excel to calculate the number of business days in a particular period? For example, a CPA preparing payroll may need to determine how many business days he or she has to ...

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, ...

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work. Image: ...