View Single Post
  #1   Report Post  
Hannes Basson Hannes Basson is offline
Junior Member
 
Posts: 1
Smile 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.