Use the date function to quickly insert the current date and time and update it in real time. You can also make a date countdown table.
Let me introduce to you three commonly used date functions.
If you want to quickly insert the current date into the table, enter =TODAY ( ).
Press Enter to enter the current date. Each time the form is reopened, the current date will be refreshed. You can also press F9 to refresh.
If you want to enter the current date and time, enter =NOW( ) and press Enter.
Each time the form is reopened, the current time will be refreshed. You can also press F9 to refresh.
To calculate the time between two dates and create a reciprocal date table, you can use the DATEDIF function.
For example, calculate how many days are left between the current date and National Day. Enter =TODAY( ) for the start date and October 1, 2019 for the end date.
Enter =DATEDIF ( ), fill in the start date, end date, and comparison unit. You can choose three options: Y represents year, M represents month, and D represents day. Enter D for the comparison unit, remember to add English double quotes.
This way you can create a countdown calendar that updates in real time.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/xin-shou-xiang-dao-chuang-jian-ge-xing-hua-dao-shu-ri-li-yu-shi-shi-shi-jian-guan-li-biao.html
支付宝扫一扫 
评论列表（196条）
测试