Hello Smart Ones!
I am looking to create a COUNTIF statement in Excel 2007 that will show me the number of times that a date appears in a given range. The only problem is the date I have is a long date, which all contain unique values. I want to use the INT function with the COUNTIF function, but am getting nowhere fast. I get the error "Your formula contains and error." Here is my formula: =COUNTIF(INT(D:D),INT(C2)).
The problem is column "D" is a long date, i.e. "2/1/2010 7:54:14 AM." They are all different values, so I want to strip out just the short date to compare. It works on the criterion section [INT(C2)], but not the range section ["INT(D:D)"].
Is there a way to do this without creating a new column for just the short date? Thanks in advance for all your help!