CODEWITHSUNDEEP
excel
OJR
OJR

Reputation: 103

Excel counting dates, a row of dates, some duplicates, for use in a graph

I have a call log exported from my phone, and I want to graph number of calls per day and do some other analytics, because of how its exported, I have a list of calls with a Datetime (see below), my first thought was a =COUNTIF(C:C, "01/09/2018") for each date I need, but something to do with how excel formats dates doesn't like it, even if I convert the Datetime to plain text, any suggestions?

enter image description here

Upvotes: 0

Views: 54

Answers (1)

BigBen
BigBen

Reputation: 50144

Use COUNTIFS and make sure your day column contains actual dates.

=COUNTIFS(D:D,">="&G2,D:D,"<"&G2+1)

enter image description here

Upvotes: 2

Related Questions