Extracting only birthday and month from ID number
Good day
I used the following function on the ID number:
3308170035186
=DATE(LEFT(D15,2),MID(D15,3,2),MID(D15,5,2))
Then I get the following: 17 Aug 1933
I want to sort the birthdays from JAN - DEC without taking inconsideration the year of birth
Hope someone can help me.
|