使用道具 举报
Book1.zip
2016-3-21 08:28 上传
点击文件名下载附件
47.55 KB, 下载次数: 9
砂海 发表于 2016-3-21 08:05 b1 输入 '0001 ,(单引号为强制文本.) b2 输入2016-1-1 ,自定义 单元格格式为 "m月" b3 输入2016-1-1 ,自定 ...
lichuanboy44 发表于 2016-3-21 08:28 =IF(AND(COUNT($C$1:C2)>0,C2""),TEXT(COUNT($C$1:C2),"0000"),"") =IF(D3"",(YEAR($B$2+ROW(A1))-YEAR($B ...
砂海 发表于 2016-3-22 07:21 , 以为你要右拉的.
砂海 发表于 2016-3-22 11:50 =TEXT(1+INT(ROW()/5),"0000") =TEXT(42370+INT(ROW()/5),"m月") =TEXT(42370+INT(ROW()/5),"d天")
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-4-24 12:56 , Processed in 0.195086 second(s), 12 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.