countif with dates

2»

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    =COUNTIFS({StartDate_Range}, IFERROR(YEAR(@cell), 0) = 2018)

    thinkspi.com

  • Thank You so much it worked. Lovely!!!

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help! yes

    thinkspi.com

  • Hi All,

    Attempting to count dates to see how many of a specific item has been completed on a specific date.

    I am using the below formula =COUNTIFS({Column Rectification Tracking Range 5}, "2018.08.28") but am getting O count

    Any idea what I am doing incorrect?

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    When referencing a specific date within a formula, you need to use the date function.

     

    =COUNTIFS({Column Rectification Tracking Range 5}, @cell = DATE(2018, 085, 28))

    thinkspi.com

  • Sean Hintz
    edited 06/22/20

    Hi, trying to do something similar to these, but failing to produce an expected return...

    My aim is to use COUNTIF to tally the number of projects that posted in a specific month range.

    In the example below I want to reference this master sheet's "Post Date (aka 'posted')" range ... {Visual Content Metrics-posted} and identify just the results at a month/year level... so the expected result of counting post dates in June would be 6 and May would = 15.

    I've not had success returning the expected results in the attempts I've made using COUNTIF(S)...

    Is there a way to write this formula:

    =COUNTIFS({Column Rectification Tracking Range 5}, @cell = DATE(2018, 085, 28))

    but return results for a month range, within the posted date range?

    =COUNTIFS({Visuals Content Metrics-posted}, [<<< ? >>>])

    Thanks very much!

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    @Sean Hintz To count for June of 2020 you can use something along the lines of

    =COUNTIFS({Other Sheet Date Column}, AND(IFERROR(MONTH(@cell), 0) = 6, IFERROR(YEAR(@cell), 0) = 2020))


    Just change the 6 and 2020 to count for whatever month/year you are wanting to count.

    thinkspi.com

  • Hi!

    I'm trying to count the number of times a client requested a project within a specific date range.

    I was able to do the first part of the formula: counting the amount of times a client's name was registered in my master sheet:

    =COUNTIFS({POC Assets count}, POC1)

    But the second part of the formula where I want to narrow it down now by date range, is the one I'm having trouble getting it right. The date range can be by month (all of August 2020 for example) or I can use two of the columns in my master sheet: Start date and Due date,

    (This formula is using the function: reference to another sheet)

    Can you please help me?


    Thank you!


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    @Andrea Antillon Which would you prefer, a specific month or a date range?

    thinkspi.com