Hi All,
Need to Count total dates available for example I need to count how many 3-Oct-2017 dates are there.
Total Count = From Data Sheet to Column "Total Dates Count" in Sheet 2.
I uses =SUMPRODUCT((INT(Data!$A$2:$A$51)=A2)) its giving me 0 count.
Please help
Attached sheet for reference
Bookmarks