Hello everyone, first time poser. I read the FAQ and i searched and searched but I could never get the words right to get the answer.
I have a column of cells with a range of dates and times:
for example:
<colgroup><col></colgroup><tbody>
</tbody>
I need the function that looks at the entire row and tells me how many cells contain 5/11 and 5/15 etc... I need it to disregard the time in the cell. and just give me the number of times the specific data appears. For example in the numbers above 5/11/18 would be 1, 5/15/18 would be 1 and 5/18/18 would be 2.
Thank you for any help.
-Jon
I have a column of cells with a range of dates and times:
for example:
5/11/2018 8:22 |
5/15/2018 8:24 |
5/18/2018 7:48 |
5/18/2018 9:23 |
<colgroup><col></colgroup><tbody>
</tbody>
I need the function that looks at the entire row and tells me how many cells contain 5/11 and 5/15 etc... I need it to disregard the time in the cell. and just give me the number of times the specific data appears. For example in the numbers above 5/11/18 would be 1, 5/15/18 would be 1 and 5/18/18 would be 2.
Thank you for any help.
-Jon