# Count dates in current month

To count dates in the current month, you can use a formula based on the COUNTIFS or SUMPRODUCT function as explained below. In the example shown above, the formula in E7 is:

where "dates" is the named range B5:B104.

At the core, this formula uses the COUNTIFS function to count dates that are greater than or equal to the first day of the *current* month, and less than the first day of the *next* month. The EOMONTH function is used to create both dates based on the current date, which is supplied by the TODAY function.

To get the first day of the month, we use the EOMONTH function like this:

EOMONTH returns the *last* day of the *previous* month, to which 1 is added to get the *first* day of the *current* month. In a similar way, we use EOMONTH to get the *first* day of the *next* month:

EOMONTH returns the *last* day of the *current* month, to which 1 is added to get the *first* day of the *next* month. The literal translation of the logic in COUNTIFS is: *greater than or equal to the first day in the current month AND less than the first day of the next month.*

Alternatively, you could use less than or equal (<=) operator for the last day like this:

### Previous and next months

To count dates in the previous month:

To count dates in the next month:

### SUMPRODUCT alternative

You can also count dates in the previous, current, and next month using SUMPRODUCT function together with the TEXT function like this:

Here, dates are fed into the TEXT function to get a month and year string, which is used for comparison in an array operation inside SUMPRODUCT. The result is an array of TRUE FALSE values, where TRUE represents dates in the month of interest.

The N function is used to change these values to ones and zeros, and SUMPRODUCT simply sums and returns the array.

## Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

## Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.