Best Microsoft Excel Bloggers

Friday, February 18, 2011

Extracting Different Parts of a Date

Extracting different parts of a date

This is just a quick tip that you might find useful. A lot of times, you have a column of dates and if you could easily extract the month and/or the year you would be able to sort or filter your data by it. It's really quite easy - you just use the Text function and the different date formats. I have a couple of examples below:

No comments:

Post a Comment


Ms. Excel- Resident Excel Geek