User Profile
Xenju1
Copper Contributor
Joined Sep 09, 2023
User Widgets
Recent Discussions
Countifs trouble
I have to keep track of request sent in daily by different people i got =COUNTIFS(Table1[Completion time],Sheet1!$B$1,Table1[Name],Sheet1!$A$2) to kinda work. The problem i am running into is on table1 the format is [Date and Time] im trying to get just the date from that table but for some reason the time is stopping me from reading the date. im really sorry for the poor explanation. i will attach SS of what i am trying todo. im trying to pull the name and the date for each person The Time wont let me read the date if i delete the time it will read it on the other sheet but id like to know if there is an easier way then going though the whole sheet deleting the time.
