- Picture and text skills
- Case
Returns the serial number of the last day of a month that is the indicated number of months after (or after) start_date.
Use the function EOMONTH to calculate expiration dates that fall exactly on the last day of a specific month.
Syntax
EOMONTH(start_date, months)
Start_date: A date value representing the start date.
Months start_date :The number of months before or after. A positive value for months produces a date in the future; a negative value produces a date in the past.
Note:You should use the DATE function to enter dates, or enter dates as the result of other formulas or functions.
For example,use the function DATE(2009,7,23) to enter July 23, 2009. The problem occurs if the date is entered as text.
Description
￭ WPSTables store dates as serial numbers that can be used for calculations. 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.
￭ If start_date is an illegal date value, EOMONTH returns the error value #NUM!.
￭ If start_date and months produce illegal date values, EOMONTH returns the error value #NUM!.
￭ If months is not an integer, it will be truncated.
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-EOMONTH-han-shu-ji-suan-dao-qi-ri.html
支付宝扫一扫 
评论列表（196条）
测试