Posted to microsoft.public.excel.misc

Stross002

external usenet poster

Posts: 5

Format Date Filter Problem

I formatted a date from 4/20/2010 to April-10 I still have a hard time
filtering
my data.

Eventhough it says April-10 it is still reading the day because the original
date had the day in it. So it is filtering the days seperatly. If I have
two dates: 4/19/2010 in row 1 and 4/20/2010 in row 2, I want to change their
format to MM-YY so I would only count 1 but it is currently counting the two
dates seperatly in my pivot table. Please help me....

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 format problem	KevHardy	Excel Discussion (Misc queries)	8	February 13th 10 09:17 AM
Excel Format Problem - Date Overrides Format	Mary	Excel Discussion (Misc queries)	5	February 10th 10 05:49 AM
Date Format Problem (bug)	Steve - Rabbit Man	Excel Discussion (Misc queries)	5	October 31st 09 01:43 AM
Date format problem	Natalie	Excel Worksheet Functions	4	June 7th 07 01:28 PM
Date format problem	Vass	Excel Worksheet Functions	7	April 3rd 06 04:50 PM

All times are GMT +1. The time now is 04:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us