Compare two dates and if they are equal
 

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

Compare two dates and if they are equal
 

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.

--
Regards,
Fred


"PeterArvidsson" wrote in message
...
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