Posts: n/a

filtering dates

hi, could you please advise me how, using advance filter, to filter a
list of dates so Im left with fridays dates only. So far Ive tried,
dates in a3:a2893, Title DATES in a2, and my criteria in A1 which is
=weekday(5) or =weekday(date)=5. Im using USE date format mm/dd/yy. Im
not sure that I setting up the advance filter correctly. Any advice
appreciated,
Regards Robert

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
Using dates for x-axis values as string instead of creating a scale	cs_weirdo	Charts and Charting in Excel	2	June 17th 05 12:20 AM
Plotting Dates	GGoetz	Excel Worksheet Functions	1	March 30th 05 10:08 AM
Formating Dates for production schedule	dpl7579	Excel Discussion (Misc queries)	1	January 11th 05 08:43 PM
due dates	Niki	New Users to Excel	4	January 10th 05 04:11 PM
Filtering with dates	T	Excel Discussion (Misc queries)	1	December 29th 04 07:01 PM

All times are GMT +1. The time now is 06:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us