Converting date into a year

hi VKS. i'm very curious of your problem. your 1st 3 solutions should work, despite the workarounds provided. the 4th solution will not because it's wrong. could you do:
=DATEVALUE(A1)
format it to a date & let me know what date does it refer to?

@ benishiryo it gives 12-Jan-13

I have already explained about this in my previous post#6 and if you subtract 1 from the year, you are good to go

Regards,
DILIPandey
<click on below * if this helps>