Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the …

See examples of how to use worksheet functions to count numbers or dates that fall within a range in Excel.

To increase or decrease a date by a certain number of days, simply add or subtract the number of days to the value or cell reference containing the date. In the example below, cell A5 contains …

Use the status bar for simple counting in Excel, or use functions to count cells that contain data, are blank, or meet specific conditions or multiple criteria.

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

Excel contains several functions to help you count the number of cells in a range that are blank or contain certain types of data. Select the cell where you want the result to appear.

How to use the COUNTIFS function in Excel to apply criteria to cells, across multiple ranges, and count the number of times all criteria are met.

Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.

Jan 1, 2008 · The DATEVALUE function converts a date that is stored as text to a serial number that Excel recognizes as a date. For example, the formula =DATEVALUE ("1/1/2008") returns …

How to sort and organize your Excel data numerically, alphabetically, by priority or format, by date and time, and more.