# Count Formula needed for Date Column

Options
✭✭✭
edited 07/08/23

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

• ✭✭✭✭✭✭
Options

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

If you were always looking for 'Today'

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

Will any of these work for you?

Kelly

• ✭✭✭
Options

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.

• ✭✭✭✭✭✭
Options

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!

Itai Perez

Reporting and Project Manager

If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

• ✭✭✭✭✭✭
Options

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

Ipshita Mukherjee

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!