Changing format of date in Excel

Big Joe - Updated on Aug 5, 2017 at 05:37 AM

Good morning,
please I have a question.

Question: Want to make use of a function such that with a date ( e.g 2/1/2017 formatted to be seen as 1-Feb-2017) the function can write out just the month after first recognising that the year is 2017.

so, the formula identifies the year first and the writes out only the month (e.g February) in the column