Formula for counting cells that have specific dates

[Trace33]

Hello,

My excel document has 2 sheets, "Disk Tracking" and "Progress." Column J in the Disk Tracking sheet is designated and formatted for dates. The current date is entered in manually for each row in that column as data is entered into each respective row (i.e. enter in disk tracking information in A4-I4 and then the current date is entered into J4). On the Progress sheet, cell C6 is designated for tracking all information entered in during the current date.

I'm looking for a formula that will count all the cells in the range 'Disk Tracking'!J3:J7000 that have the current date in them so that 'Progress'!C6 will show how many rows data has been entered in today. I've played around with CountIf and SumProduct formulas but can't seem to get anything to work.

Note: If it helps to have a match function of some kind, cell 'Progress'!C2 has the =Today() formula in it.


Thanks for the help!

 

[Trace33]

Figured it out

=COUNTIF('Disk Tracking'!J:J, VALUE(C2))