怎么样制作一份考勤表！！能够更新日期！！简单教程一步教会你！！
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">在<span style="color: black;">平常</span>办公中，<span style="color: black;">由于</span><span style="color: black;">有些</span>工作职位的<span style="color: black;">需求</span>，需要制作<span style="color: black;">机构</span>员工的考勤表，<span style="color: black;">咱们</span>常用的<span style="color: black;">便是</span><span style="color: black;">运用</span>Excel表格制作，为了方便实时记录考勤，更新日期时间，动态考勤表格时必不可少的一种表格，<span style="color: black;">那样</span><span style="color: black;">怎样</span><span style="color: black;">运用</span>Excel制作动态考勤表呢？下面就给<span style="color: black;">大众</span>介绍一下制作<span style="color: black;">办法</span>。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJGUibjpGSXgTyQQ9UibqB1WgMPUhBVxffAdwd3LPpe3GcTOA7T1Qsbpbg/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">封面</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">办法</span><span style="color: black;">过程</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1、新建一个空白的Excel表格，先在制作一行考勤时间内容行（如图1）。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">注：在年份“2023”和月份“12”后方需各自留出空白单元格位置<span style="color: black;">安置</span>数值调节按钮。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJfkeU1fDT2rIaeb0P2OibA6Eib00EyjELc9td8eFJnTgRKvlPDFbZg2ibQ/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图1</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2、点击【<span style="color: black;">研发</span>工具】-【<span style="color: black;">插进</span>】-【表单控件】-【数值调节钮】，<span style="color: black;">而后</span>按住鼠标左键，分别在年份“2023”和月份“12”后空白单元格绘制按钮。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJbYRSibsCsrECg8vFrhZJ1cubOxQWCuuic2qIBlt6DGOGWFvY8eib35qrQ/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图2</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJOIwjuFSvJL6T8dNJ2FpZiaOtd2wAwlsIbnrddJVk2dxgicMOocWzs9cg/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图3</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">3、选中年份“2023”后方的按钮，单击鼠标右键点击【设置控件格式】，在弹出的对话框中点击【控件】，设置参数①②③。<span style="color: black;">而后</span>点击【确定】，<span style="color: black;">这般</span>点击年份后按钮，年份就<span style="color: black;">能够</span>调节变化。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">①“当前值”：2023；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">②“最小值”和“最大值”可<span style="color: black;">按照</span>需要<span style="color: black;">自动</span>设置；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">③“单元格链接”为：$C$1（即：年份2023所在单元格）。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJ5QnysXjicHSW64qU1lcBFjA6ZicQ3HgRYRqG3Hre4TUUqriaPgemR6Bng/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图4</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJS1Q5ZAPhQJcibc4DzCcZQ1n0pcnr1kmiaOGJLwY1FOCPb33zxIkHymcA/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图5</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">4、<span style="color: black;">一样</span>的<span style="color: black;">办法</span>，选中月份“12”后方按钮，单击鼠标右键点击【设置控件格式】，在弹出的对话框中点击【控件】，设置参数①②③，<span style="color: black;">而后</span>点击【确定】，<span style="color: black;">这般</span>点击月份后按钮，月份就<span style="color: black;">能够</span>调节变化。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">①“当前值”：12；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">②“最小值”:1，“最大值”：12；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">③“单元格链接”为：$F$1（即：月份12所在单元格）。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJTFBlsoYQp5CdGJ3xs0WYMib75BtXOib3kwglMVnRsyU1IibuUs4tY8m8w/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图6</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">5、在考勤时间行的上方<span style="color: black;">插进</span>一行空白行（用为考勤表标题行），<span style="color: black;">而后</span>在<span style="color: black;">第1</span>个单元格输入公式：=C2&"年"&F2&"月考勤表"，输入完成按【enter】键，<span style="color: black;">这般</span>就得到一个动态的标题，<span style="color: black;">能够</span>随着考勤时间行内的时间更新。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">注：【C2】指的是考勤时间行的年份单元格；【F2】指的是考勤时间行的月份单元格。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJQDxPDsjmLOBWrYM6goIT5NVibOjHCbKjQVP1TGMnuEzPxAIAAG0OuWw/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图7</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJFZrLH67rUib1Ie8w2xb18Fs99MEkCYmjINo9ibQj6ibysMPaHUR1WNQnA/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图8</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">6、在表格中制作好考勤姓名/星期/日期的斜线表头和人员（如图9），<span style="color: black;">而后</span><span style="color: black;">选取</span>日期行<span style="color: black;">第1</span>个空白单元格，输入公式：=DATE($C$2,$F$2,1)，输入完成按【enter】键得到一个日期。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">注：【$C$2】指C2单元格（即：考勤时间行的年份单元格）按一次F4锁定；【$F$2】指F2单元格（即：考勤时间行的月份单元格）按一次F4锁定；【1】指每月的1号。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJD8foPmtppCZRGy10EUCVBSV9qSDbIW0JgXWI6FhRHquYYQle28ficHQ/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图9</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJwB6FHWdibJyPznib4ribwX0mYys2KVMxvR5jdGXQEOScunE0WY7IRN56w/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图10</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">7、选中输入公式的日期单元格，单击鼠标右键点击【设置单元格格式】，在弹出的对话框中点击【数字】-【自定义】，在右侧“类型”栏输入：d，<span style="color: black;">而后</span>点击【确定】，<span style="color: black;">这般</span>就<span style="color: black;">能够</span>得到一个带年月日格式的日期。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJPtG6QAamk1lOGb81prec9qUmpO27kqrYyiapbSQ7un2uZNjkapCx88A/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图11</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJXBaAIgRiaLeGfTKCf5rMDHsTCfOL9R6j5NYIqZf7Iv6bUUnUeqIVgsA/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图12</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJ922uZooicXmzxt9pfdbsOV3xcbjbEp5y8II6ETp3RiaUgmWjaVRbtn1g/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图13</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">8、在日期行第2个单元格输入：=C3+1（即：<span style="color: black;">第1</span>个日期加1），输入完成按【enter】<span style="color: black;">就可</span>，<span style="color: black;">而后</span>将鼠标移动到单元格右下角，当光标变成+时，向右填充至日期31为止。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJEb5ZOkrwcPgSVSzu4Aeauslz1l0DDDPv7C4mSmpvBnzwj6PNhZSFGA/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图14</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJUkd3ia4s3JjgiaVzWOSu96IblnnAmNzmGmfxdrxsdwjsOGJiaPNoJbhNA/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图15</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">9、<span style="color: black;">选取</span>星期行<span style="color: black;">第1</span>个空白单元格，输入公式：=C3（即：即日期行<span style="color: black;">第1</span>个单元格），输入完成按【enter】键。在单元格上单击鼠标右键点击【设置单元格格式】，弹出的对话框中点击【数字】-【日期】，在右侧“类型”栏<span style="color: black;">选取</span>：周三，再点击【确定】，<span style="color: black;">这般</span>就<span style="color: black;">能够</span>得到一个星期格式的日期，<span style="color: black;">而后</span>将鼠标移动到单元格右下角，当光标变成+时，向右填充与日期行对齐<span style="color: black;">就可</span>。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJcEic3LlKFwIb9MZOcYs2qdoFsZmTdlXqV4BPmsjoUcqs4dCeN0T7R0A/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图16</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJJH51tHs4uX57zGtzKQtibC3iapCD3o6OaNZTvicAiakUzWuQV3pdluklNw/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图17</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJhHEasYfvibkiaeT92CXLlKEndNcWfZSJiaGKyncE5xk4NhQ7IibjJE59PA/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图18</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">十、</span>选中考勤表中勾选考勤的<span style="color: black;">所有</span>单元格区域，点击【数据】-【数据验证】-【数据验证】，在弹出的“数据验证”对话框中点击【设置】，将“<span style="color: black;">准许</span>”设置为：序列；在“<span style="color: black;">源自</span>”中输入：√,○,△,☆,×（即：考勤标记的<span style="color: black;">各样</span>符号，中间用英文状态下输入的逗号隔开），<span style="color: black;">这般</span>考勤记录区域的下拉菜单就设置完<span style="color: black;">成为了</span>。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJmAXHXoALUa6ua8BgdI5lvrDtbibDEqJ6Es6UibYfYicJHZ1oOja2lkrnQ/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图19</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJC3eLZXmFWBdwuqamAB4aiaAlIiblNP6oxuCaib4WRHDbMwLnfsa7oM86g/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图20</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJgbAEVCxSAtP1WJ5qd9gI22V5uzT0xs3WnFymJicniaEzoETRqlicDrLRg/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图21</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">11、<span style="color: black;">这般</span>动态考勤记录表就设置完成，再<span style="color: black;">按照</span><span style="color: black;">自动</span>需要设置好表格样式，<span style="color: black;">就可</span><span style="color: black;">按照</span><span style="color: black;">每一个</span>人<span style="color: black;">每日</span>的考勤记录，且点击时间考勤表日期星期<span style="color: black;">亦</span>会随着改变。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_jpg/XV35THXxp0WicWZWbcCxAkrvHgtpejFMJg5qUibDaGsm8B7YflRmQtY01gwKH0KQibhfeKa0VW3Qo5LBUrqRQdxNA/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
感谢楼主的分享！我学到了很多。 大势所趋，用于讽刺一些制作目的就是为了跟风玩梗，博取眼球的作品。 外链论坛的成功举办，是与各位领导、同仁们的关怀和支持分不开的。在此，我谨代表公司向关心和支持论坛的各界人士表示最衷心的感谢！
页:
[1]