Filtering Dates

[teck91]

hi,

i am trying to filter dates on excel and can not figure out how to, i want to filter by month to any help would be much apriciated.

mason.

[NBVC]

in a separate column enter something like:

=Month(A2) and copy down.. where A2 contains first date in your database... then you can filter by the month number in this column...

If want to display month in text... then use: =Text(A2,"mmmm") copied down

[teck91]

this is what im working with as you can see there are 2 dates when it was made and when it is travelling i need to count5 how many are travelling in certain months im really new to excel and dont really understand it to much.


28-Feb-10 Richard Alty reevesd1 07/08/10 2 0 0 ***NCL **VRN ****10 VAG DH14DU1 Waiting
28-Feb-10 Steven Patrick Brownan1 31/07/11 2 0 0 ***LGW ** ****14 PE131LS1 Waiting
28-Feb-10 Andrew Cox reevesd1 28/12/10 4 2 0 ***MAN **INN ****7 OBE L374HT1 Waiting
28-Feb-10 Maureen Martin Brownan1 12/06/10 2 0 0 ***MAN **LJU ****7 KRA CH435XB2 Waiting
28-Feb-10 Angela vincene1 10/07/10 2 0 0 ***MAN **SZG ****7 VNA M178AP26 Waiting
28-Feb-10 Hillary Brownan1 28/02/10 2 2 0 ***BHX **CMF ****7 BRI LE99JR3 Waiting
28-Feb-10 Hillary Brownan1 28/02/10 2 3 0 *** ** ****7 LE99JR3 Waiting
28-Feb-10 Mrs Mitchell boylana1 27/03/10 2 3 0 ***LGW **INN ****7 GU72PR1 Waiting
28-Feb-10 Mr Cook reevesd1 20/02/10 2 0 0 ***LGW **TRN ****7 TON NR337LX2 Waiting
28-Feb-10 Mr. Thomas murtadv1 28/02/10 0 0 0 *** ** ****7 SA16XP1 Waiting
28-Feb-10 Elen Brownan1 28/02/10 1 0 0 *** ** ****7 BH151AN14 Waiting
28-Feb-10 Mr. Thomas murtadv1 20/03/10 9 0 0 ***CWL ** ****7 SA16XP1 Waiting
28-Feb-10 Agent Jan = Client Graham hensmal1 13/02/11 11 4 0 ***BRS **TRN ****7 SAU BR11DG361 Waiting

[teck91]

sorry the first date shown in 28-feb-10 is not the date i need to filter its the one 28/02/10 in that format

[NBVC]

So assuming those dates are in Column E... then put a formula in the column after the last used column: =TEXT(E2,"mmmm") and copy it down the column by clicking and dragging down the little black square at bottom right corner of the cell...

then go to Data|Filter|Autofilter.. click the arrow in the added column and select the month to filter for.

[ChemistB]

If you want to make a separate little table, let's say in N1:O12, In N1:N12, type the full name of the months (January, February, etc), Assuming your travel dates are in Column C1:C100, in O1, dragged down, you can put this formula

=SUMPRODUCT(--(TEXT($C$1:$C$100,"mmmm")=N1),--ISNUMBER($C$1:$C$100))

Does that work for you?