Excel公式获取文件名截取对应日期
=MID(MID(CELL("filename",A445),FIND("[",CELL("filename",A445))+1,FIND("]",CELL("filename",B453))-1-FIND("[",CELL("filename",A445))),10,10)
Excel公式获取文件名截取对应日期
=MID(MID(CELL("filename",A445),FIND("[",CELL("filename",A445))+1,FIND("]",CELL("filename",B453))-1-FIND("[",CELL("filename",A445))),10,10)