Date conversion

Closed
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.