- Picture and text skills
- Case
Returns a number representing the week of the year.
Syntax
WEEKNUM(serial_num,return_type)
Serial_num represents the day of the week. 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.
Return_type is a number, determining the day of week calculation from Which day to start. The default value is 1.
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
Theserial 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-WEEKNUM-han-shu-ji-suan-xue-qi-zhou-shu.html
支付宝扫一扫 
评论列表（196条）
测试