:Date and time function YEARFRAC function Proportion of a period of date to the date of the whole year-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. Date and time function YEARFRAC function Proportion of a period of date to the date of the whole year

Date and time function YEARFRAC function Proportion of a period of date to the date of the whole year

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

Returns the number of days between start_date and end_date as a percentage of the number of days in the year.

Use the YEARFRAC worksheet function to determine the proportion of annual benefits or debt under certain conditions.


Syntax

YEARFRAC(start_date, end_date, basis)

Start_date: A date value representing the start date.

End_date: A date value representing the end date.

Basis: The type of day counting basis to use.

image.png

For example,use the function DATE(2009,7,23) to enter July 23, 2009. The problem occurs if the date is entered as text.

Note: Dates should be entered using the DATE function or as the result of another formula or function.


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 or end_date is not a valid date, YEARFRAC returns the #VALUE! error value.

￭ If basis < 0 or basis > 4, YEARFRAC returns the #NUM! error value.

￭ All parameters 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-YEARFRAC-han-shu-yi-duan-ri-qi-zhan-quan-nian-ri-qi-bi-li.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu topimage.cn Columnist
48 196
single-end

Related Suggestion