Date conversion

jansal Posts 1 Registration date Tuesday October 20, 2015 Status Member Last seen October 20, 2015 - Oct 20, 2015 at 06:55 PM
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.