Date field and checking the Date portion of the date field not the time

[badmullah]

If my date fields are in G column and i want to count how many of them match the date part of the field say 15/02/22 ( Put into CELL C2 ) how do i do the COUNT formula?
would that be ?
=COUNTIF(G1:G9999, ?????)

Thanks

[TMS]

If K2 contains the date you are looking for:

Please Login or Register  to view this content.

[badmullah]

Hi
Sorry I could not get it to work - I have uploaded the XLS . in Output Sheet Cell C1 i m trying to fetch the count of records in the other sheet that in its G column all the dates that contain the value of C2
Thanks

[wk9128]

worksheet or Tab name : Output

Cell B2 formula

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

[badmullah]

last question
If I put 2022/02/15 in a Text Cell say D2

can i use =SUMPRODUCT((Closed!F2:F9000="COMPLETE")*(TEXT(Closed!G2:G9000,"yyyy/mm/dd")=D2)) ?

[wk9128]

try this formula , unless your D2 storage format is text input

TEXT Format = text format

Please Login or Register  to view this content.

OR value format = value format

Please Login or Register  to view this content.

[wk9128]

@badmullah You're Welcome. Glad to help . Thank You for the feedback and rep.

If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the text PREFIX on the upper left, press the button to select [SOLVED]

[kvsrinivasamurthy]

Your formula corrected

=SUMPRODUCT(--(INT(Closed!$G$2:$G$1048)= INT(C2)))

[TMS]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.