If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
suggestions on creating a text value based on a date range
I have a situation where I need to compare week1 from one year to week1 from
another year. The problem is that I have the dates, amounts, and categories in a raw dump from an external application in a text file and am able to import it into Excel. The issue that I need to do is to be able to create another column that will contain the week identifier based on the date column. example: Category Date Amount 35 4/18/2005 120.00 35 4/18/2005 170.00 36 4/19/2005 322.00 .. .. .. 45 4/22/2006 118.00 46 4/23/2006 131.00 45 4/23/2006 96.00 With a helper column, I should be able to create a pivot table that is based on the helper column (week number), instead of the week so I can get totals for the week instead of for the day. Does anyone have any suggestions on how to create this helper column? The data source has over 16000 lines and I don't want to have to manually enter values (even with copy and paste) for this many lines of data. Any and all assistance will be greatly appreciated. Thanks in advance, Allen -- |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
forms for tables set up as "one to one" | Babe in the Woods | New Users | 7 | February 23rd, 2006 09:45 AM |
Creating dynamic cross reference links in a Word document | torajudo | General Discussion | 4 | October 25th, 2005 03:51 PM |
Change font of part of text | John | Powerpoint | 7 | March 15th, 2005 10:10 AM |
Help with design | Ronnie | Database Design | 6 | March 12th, 2005 02:53 PM |
Office 2003 installation problem, log file attached.... | Ryan | Setup, Installing & Configuration | 0 | January 20th, 2005 06:57 PM |