98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » List management
List management
Resolved · Urgent Priority · Version 2003
Jane has attended:
Excel Intermediate course
Excel Advanced course
List management
I seem to remeber there was a way to do the following but I can't remember how....
I have a data list, one colum is a date (eg 03/10/2008). I woul like to add a new column that just gives the month (eg October).
The data list is over 1000 long and 10 columns.
I hope this is something Excel can do quickly rather than me doing it manually!
Thanks
RE: List management
Hi Jane
Thank you for your question and welcome to the forum.
I think you should be able to do this using a combination of the MONTH function and VLOOKUP function.
I've attached an example. I created a formula in B1 that looks at the date (in A1) and figures out which month the date is in using the date function. This returns the number of the month (i.e. January = 1, February = 2 etc) so then the VLOOKUP function looks up the month that corresponds to the number in the table to the right. You could set up the table for the VLOOKUP on a different sheet if you like, and it would still work.
I hope this helps.
Amanda
Attached files...
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:COUNT function vs COUNTA functionThe COUNTA function works in the same way as the COUNT function, except that it will count cells that contain text (labels) and also cells that contain numbers (values). The COUNT function will only count cells that contain numbers. Blank cells are not counted by either the COUNT or the COUNTA function. |