keeping both dates when doing analysis
Thanks for your response!
I just bought the book "pivot table crunching" by MrExcel and look forward to doing my analysis using pivot table charts and tables.
Both dates are important to determine weekly trends.
Since I need both dates should I:
#1 use text a column creating 2 date ranges
#2 Fomat new column mdy
or import the start of each week only and do the same?
I want to be able to show graphs, charts etc using pivot tables but also want the dates in order when doing analysis.
Thanks again,
Art