How to extract Day, Month and Year in different cells from a Date in Excel (Two Different Ways)

In this tutorial, we would be using two ways to extract Day, Month and Year from a Date. First way, would be through Text-to-Column and the other way would be by using the DAY(), MONTH() and YEAR() functions