convert date column to general value

I am trying to upload excel data to a databse which only accepts general values. Some one tried to help me with formulas as per attached word document but it is not working. I get #value as result. (cell colored red)

need to Import this Excel sheet into an AMS Database system - All Cells NEED "general" value even if its numbers.

Tried doing manually but main sheet has 3500 entries...:-(

I am sure there has to be easier way to do this.

Your help is higly appreciated

Thanks much

vikkam confused: