- Picture and text skills
- Case
Returns the serial number corresponding to the current date and time. If the cell is formatted as "General" before entering the function, the result will be formatted as a date.
Syntax
NOW()
Description
• WPSTable can store dates that can be used for calculations serial number. By default, the serial number for December 31, 1899 is 1, and January 1, 2008
's serial number is 39448 because it is 39448 days from December 31, 1899.
• The number to the right of the decimal point in the serial number represents Time, the number on the left represents the date. For example, a sequence number of .5 indicates the time is 12:00 noon.
• Function NOW only works when recalculating the worksheet , or changed when executing a macro containing this function. It is not updated at any 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/ri-qi-he-shi-jian-han-shu-NOW-han-shu-cha-ru-shi-shi-shi-jian-bing-zi-dong-geng-xin.html
支付宝扫一扫 
评论列表（196条）
测试