Compare two dates and if they are equal

P

PeterArvidsson

Hi,

I want to want to able to write a date on one sheet and this date will
filter away all other dates, exept the choosen date, in another sheet. And
from this filter a will do a count on how many cells with this date.

Is this possiable?

/Peter
 
F

Fred Smith

You're really talking about two separate actions -- the filter and the count.

To do the filter, with your selection in a cell, you need to use Advanced
Filtering (under the Data menu).

To do the count, simply use the Countif function.

Post back if you need more help with either of these.
 
Top