Date issue format

Hello Everyone,

I am having troubles converting excel cells into a year format.
Can someone please help? I have attached the file.
Basically, I am trying to get the "year" (date format) for the year of incorporation but unfortunately it seems like column A has two types of format.

Thanks in advance for your help!