1、首先我们需要双击桌面上的 excel2010 快捷方式以运行应用程序。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0b7b02087bf40ad1353b4d48592c11dfa8ecceba?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、选择单元格a1,在该单元格中输入=now()后按回车键。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9358d109b3de9c8208410c246281800a19d84371?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、接着在单元格a1中就会显示当前的日期时间,选择单元格a2
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b3119313b07eca80ffc6b34c9f2397dda044835e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、然后我们需要在a2中输入=CHOOSE(WEEKDAY(A1,2),"星期一","星期二","星期三","星期四","星期五","星期六","星期日")公式。输入完成后按回车键,你会看到在单元格a2中显示出正确的星期几。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/2e2eb9389b504fc2626145aeebdde71190ef6d5b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、最后就完成了自动获取当前日期时间和周数的方法, 当您保存并再次将其关闭时, 您会发现时间已相应地更改。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d1160924ab18972bc601f561e8cd7b899e510a65?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)