使ç¨textå½æ°å¤ç=TEXT(NOW()+row(a1),"aaaa e-m-d")
说æåæ¼ç¤ºï¼
1ãéæ©A1åå æ ¼
2ãè¾å ¥å ¬å¼=TEXT(NOW()+row(a1),"aaaa e-m-d")
3ãä¸æå®æ
å ¬å¼è§£æï¼
1ãrowè¿åè¡å·å½æ°ï¼row(åå æ ¼å°åï¼ï¼è¿åå ¶è¡å·ï¼row(A1)å°±æ¯1ï¼ä¸æåærow(A2)=2,ä¾æ¬¡éå¢
2ãnow()å½æ°ï¼è¿åå½åçæ¥æ
3ãtextå½æ°ï¼æ ¹æ®ç¬¬äºåæ°ï¼è¿å对åºçæ ¼å¼ï¼aaaa 表示ææ?,e-å¹´ï¼m-æï¼d-天