I've a column of dates in my table more than 300.000 rows formatted as dd-mm-yyyy
. now I'll from all rows the month in text and the year. How can I do that on the fast way?
Example table:
+----------+------------+----------+---------------+------+
| Number | Date | Hours | Month in text | Year |
+----------+------------+----------+---------------+------+
| 1 | 01-01-2010 | 0:00:00 | January | 2010 |
| 2 | 01-02-2010 | 0:00:05 | February | 2010 |
| ... | ... | ... | ... | ... |
| 325.696 | 01-12-2014 | 23:59:55 | December | 2014 |
+----------+------------+----------+---------------+------+
I'm not so good whit working with Excel. So can you give me also a formula to calculate it. Is there also a fast way to calculate that for all the rows?