I have a column named Birthday and a field on it would be: 04/11/1998; How can I create a calculated column namd BirthGET that contains only day and month, i.e 04/11.

How can I make this?

Thanks for your time!


I wouldn't use an index counter as mentioned by Amal...

Here is what I would use =TEXT([Birthday],"mm/dd") This is a more well rounded solution which will allow you to do more.

This will give you exactly what you are looking for. Both methods will work for you but this will give you exactly what you want if the date is oriented if displayed worded or in number format. You can also transpose the date into worded date format by using mmmm, dd yyyy


You can use below formula

=LEFT(BirthDay, 5)
  • this is not working it is generating unknown number for me! – Nderon Hyseni May 6 '16 at 12:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.