Count Formula needed for Date Column

Gina McK

What formula would I use for a date column to count the number of times the same date appears?

Kelly Moore

Hey @Gina McK

The function you will use is a COUNTIFS function. It has the syntax COUNTIFS(range 1, criteria 1, range 2, criteria 2, and on and on). You always make sure you are adding terms to a COUNTIFS in a range-criteria pair.

Depending on what you need, your formula will vary slightly. If you are looking for a specific date, you can hard code that directly into the formula:

For example, if you were looking for 08-Jul-2023

=COUNTIFS([your date column]:[your date column], DATE(2023, 7, 8))

If you were always looking for 'Today'

=COUNTIFS([your date column]:[your date column], TODAY())

and if you're looking for the date to vary depending on what is in a cell on the row then

=COUNTIFS([your date column]:[your date column], [your date column]@row)

Will any of these work for you?

Kelly

Gina McK

What I need the formula to do is find all the dates are the same and count them so if 7/13/23 shows up 4 times in a column the formula will yield = 4

This is a log where many entries will exist for the same date. I will need to know how many entries exist for each date entered. I hope that makes sense.

Itai Perez

Hey @Gina McK,

Like @Kelly Moore sugested you should use COUNTIF.

You can create a new sheet with a column that has all the dates you would like to count.

Then in a column next to it you would add the formula Kelly mentioned:

I hope that helps!

Ipshita

Hey @Gina McK ,

My comment never posted and remained in drafts! :(

Please use the following formula to calculate the number of times a date appears if you have a particular date to count.

Hope this helps,

Cheers!

Ipshita