There are DAY(), MONTH() and YEAR() functions in Excel, that will split as you desire.