Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I compare two dates? | Excel Worksheet Functions | |||
Show dates if multiple Serail numbers are equal | Excel Discussion (Misc queries) | |||
Compare date of a transaction against a range of dates | Excel Worksheet Functions | |||
Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
Compare range of dates and sum... | Excel Discussion (Misc queries) |