按题意应该有一个日期列！假设日期列是A列在B1输入 =TEXT(A1,"YYYYMMDD")&TEXT(ROW(A1),"000")在B2输入 =TEXT(A2,"YYYYMMDD")&IF(A2=A1,TEXT(RIGHT(B1,3)+1,"000"),TEXT(ROW(A$1),"000"))然后选中B2下拉即可！要是有问题HI我！
