Filter date by month and year

Posted to microsoft.public.excel.programming

Peter[_61_] Peter[_61_] is offline

external usenet poster

Posts: 48

Filter date by month and year

I have a column of dates that I am trying to filter on just the month
and year.

Date
22/05/1981
16/03/1981
26/01/2006
01/05/1986

Is it possible to filter on only the last 4 digits of a cell?

Thanks,

Peter

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Date(Year,Month,Day) not returnign correct date	jlclyde	Excel Discussion (Misc queries)	8	October 16th 09 02:42 PM
count month when date is in day/month/year format	ccKennedy	Excel Worksheet Functions	6	April 30th 09 03:32 AM
=DATE(YEAR(P4),MONTH(P4)+1,1)	[email protected]	Excel Worksheet Functions	3	January 22nd 09 04:37 PM
Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)???	misscrf	Excel Discussion (Misc queries)	1	December 14th 07 02:59 PM
Sort month/date/year data using month and date only	SMW820	Excel Discussion (Misc queries)	6	June 22nd 06 05:14 PM

All times are GMT +1. The time now is 03:18 PM.

Menu

About Us