:Date and time functions: Use the YEAR function to extract the year in one second-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. Date and time functions: Use the YEAR function to extract the year in one second

Date and time functions: Use the YEAR function to extract the year in one second

Author: daogeziyuan • • Table skills • Views 965
  • Picture and text skills
  • Case

Returns the year corresponding to a date. The return value is an integer between 1900 and 9999.

Syntax
YEAR(serial_number)
Serial_number represents a date value that contains the year you are looking for.

Dates should be entered using the DATE function or as the result of another 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-YEAR-han-shu-yi-miao-ti-qu-nian-fen.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu Bu明 Columnist
48 196
single-end

Related Suggestion