0 |
Subject: (yey Another!) Excel question!
Posted by: rockafellerskank
- Dude [27652109] Thu, Nov 18, 2004, 18:58
I have 20,000 lines of data that all start with a date. Various dates from 1/1/01 to 11/15/04. I care about the "month" these transactions occured, but not necessarily the "day of the month" I want to convert them so that I can use them in a pivot table.
Obviously, I tried reformmating the date from 1/1/01 format to Jan-01 format which works fine, except when you create a pivot table, the table still thinks the dates are 1/1/04, 1/2/04, 1/3/04.... 1/31/04, etc.. So, my question is, how can I format not only the display of the data but the actual cell to read month-by-month?
I also didn'y really want to type a 48 If/Then true-false type of a statement if at all possible (to account for 48 separate months of transaction data). |
1 | RecycledSpinalFluid Dude
ID: 204401122 Thu, Nov 18, 2004, 21:50
|
Can you add another column that says this:
=MONTH(A1) & "/" & YEAR(A1)
Where A1 is the date column?
|
3 | rockafellerskank Dude
ID: 27652109 Thu, Nov 18, 2004, 23:10
|
Yep. That nifty little trick worked. Thanks "Dad"
|
|
|
Post a reply to this message: (But first, how about checking out this sponsor?)
|
|