The COUNT function returns the number of cells in a range or array that contains numeric values. These values can be integers, decimals, dates or even numbers enclosed in quotations.

How to Count Excel Cells Based on a Condition . Not to be confused with the SUM function, which adds up numerical values ...

If you need to count or calculate number of Leap Years between two dates in Excel or list of two dates in Excel, make use of this formula to get things done.