Forum Discussion

Ramon Haagen's avatar
Ramon Haagen
Copper Contributor
Apr 06, 2019
Solved

Countifs and how to ignore timestamp

I want to use countifs to count a specific criteria on a certain date however in the date cell is also a timestamp. Because of this it doesn't count any other cell with this date because the time sta...
excel
Formulas and Functions
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 06, 2019

    Ramon Haagen , above formula was only mock-up, you shall use your actual ranges and criteria cells. In your case that's

    =COUNTIFS(tbl_Activity_registration_1[Saved_on],">="&$A3,tbl_Activity_registration_1[Saved_on],"<"&$A3+1)

    But I don't see any time with your dates, thus that could be slimly

    =COUNTIFS(tbl_Activity_registration_1[Saved_on],$A2)

    (column Y in attached)

     

     

Resources