Date conversion

I want to convert a date in excel into a separate columns for month and year. I have converted the format from dd/mm/yyyy to series number and used the convert month and year in formula. The problem is that it works on occasions and not on others.