Sometimes, you need to extract different parts of a date to do, for example, comparison. Some people may think of doing a text to column to split parts of date. However, that would not work. Even if it was, it isn’t a good method. Luckily, there are built-in methods in Excel that help you do just that: extracting parts of a dates (years, months…)
Here are the parts of a date you can extract:
- Year
- Month
- Day
- Weekday
- Weeknum
Let’s look at an example. The date in our example is the final date of 2017: 31/12/2017.
From the results, you can see that 31/12/2017 has the year 2017, the month is 12, the day is 31 (all visible when you look at it). Also, you can see that it’s the first day of the week (Sunday) and of week 53. The last two bits of information you cannot tell when you look at the date.
Now you’ve learned a few very useful functions to extract information from a date. If you like this post, don’t forget to share.