:Date and time functions: Use the DAY function to display the number of days in a date-Table skills免费ppt模版下载-道格办公

Date and time functions: Use the DAY function to display the number of days in a date

  • Picture and text skills
  • Case

Returns the number of days in a date as a serial number, expressed as an integer from 1 to 31.

Syntax
DAY(serial_number)
Serial_number represents a date value that contains the date you are looking for. Dates should be entered using the DATE function, or as other

The result input of a formula or function.

For example, use DATE(2008,5,23) to enter May 23, 2008. Problems arise if the date is entered as text.

Description
WPSTable can store dates as data 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.

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-qiao-yong-DAY-han-shu-xian-shi-ri-qi-tian-shu.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
single-end

Related Suggestion