- Picture and text skills
- Case
Returns a serial number representing a date that is the indicated number of months before or after the specified date (start_date).
Use the function EDATE to calculate the expiration date that falls on the same day in January as the issue date.
Syntax
EDATE(start_date, months)
Start_date A date value representing the start date.
Months The number of months before or after start_date. A positive value for months produces a date in the future; a negative value produces a date in the past.
Note: The DATE function should be used to enter the date. Or enter a date as the result of another formula or function.
For example, use the function DATE(2009,7,23) to enter July 23, 2009. The problem occurs ifthe date is entered as text.
Description
￭ WPSTable stores 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 not a valid date, EDATE returns the error value #VALUE! .
￭ 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-qiao-yong-EDATE-han-shu-pi-liang-ji-suan-dao-qi-ri.html
支付宝扫一扫 
评论列表（196条）
测试