Count Formula needed for Date Column

Gina McK
Gina McK ✭✭✭
edited 07/08/23 in Formulas and Functions

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

Answers

  • Kelly Moore
    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
    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
    Itai ✭✭✭✭✭✭

    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

    Project Manager | Transformation Department

    Gong cha

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

    https://www.linkedin.com/in/itai-perez-740543116/

  • Ipshita
    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

    Ipshita Mukherjee

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!