Date conversion [Closed]

Report
Posts
1
Registration date
Tuesday October 20, 2015
Status
Member
Last seen
October 20, 2015
-
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.