Excel date [Closed]

Report
Posts
1
Registration date
Wednesday February 28, 2018
Status
Member
Last seen
February 28, 2018
-
i have 5000 different dates
for the period 01-04-2010 to 31-3-2011 i wish to mention as 2010-11 at the left coloum as the year pertaining to

how to do in excel