excel 日期转换数字问题解决

="update p_doc_year set vc_year = '"&TEXT(B1,"yyyy-MM-dd")&"' where l_doc_id = (select l_doc_id from OLD_PROJECT_DOC_R where l_old_doc_id = "&A1&");"