Hello Everyone,

In a cell I have date 01/11/2015 and I want to extract only year so I am using =RIGHT(A1,4) this formula but this formula returning 2005 which is wrong.

Please suggest how can I extract year only from the date.

Thanks