- Picture and text skills
- Case
According to the algorithm of 360 days in a year (each month is counted as 30 days, a year totals 12 months), returns the number of days difference between two days, which is used in some accounting calculations
中will be used. If your accounting system is based on a 12-month, 30-day month, you can use this function to help calculate payments.
Syntax
DAYS360(start_date,end_date,method)
Start_date, end_date: The start and end dates for calculating the number of days in the period.
If start_date is after end_date, DAYS360 will return a negative number.
Method: a logical value, which is specified in Whether to use the European method or the American method in the calculation.
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
WPSTable can 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.
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-DAYS360-han-shu-ji-suan-xiang-cha-tian-shu.html
评论列表(196条)
测试