EXCEL在sheet1打日期,sheet2sheet3中如何自动生成日期答:引用位置框中,输入 =REPLACE(CELL("filename",!A1),1,FIND("]",CELL("filename",!A1)),"")三、选中sheet2到sheet31(点sheet2,按shift键不放,再点sheet31可以选中)点到A1单元格,输入公式 =DATE(YEAR(Sheet1!$A$1),MONTH(Sheet1!$A$1),DAY(SUBSTITUTE(LOWER(sheetnam),"sheet","...