Count Formula needed for Date Column
![Gina McK](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
What formula would I use for a date column to count the number of times the same date appears?
Answers
-
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
-
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.
-
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🙂
https://www.linkedin.com/in/itai-perez/
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!