Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
PeterArvidsson
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I compare two dates? SlipperyPete Excel Worksheet Functions 3 April 19th 06 05:40 PM
Show dates if multiple Serail numbers are equal Dark_Templar Excel Discussion (Misc queries) 6 April 8th 06 06:09 AM
Compare date of a transaction against a range of dates D Campbell Excel Worksheet Functions 1 August 7th 05 09:40 PM
Compare dates (one cell not in date format) craigcsb Excel Discussion (Misc queries) 5 June 28th 05 05:07 PM
Compare range of dates and sum... SAL Excel Discussion (Misc queries) 5 March 22nd 05 03:59 PM


All times are GMT +1. The time now is 11:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"