:Date and time functions DAYS function-Table skills免费ppt模版下载-道格办公

Picture and text skills
Case

Returns the number of days between two dates.

Grammar

DAYS(end_date, start_date)

DAYS function syntax has the following parameters.

End_date Required. Start_date and End_date are the start and end dates used to calculate the number of days in the period.

Start_date Required. Start_date and End_date are the start and end dates used to calculate the number of days in the period.

Note: The table can store dates as serial numbers so they can be used in calculations. By default, the serial number for January 1, 1900 is 1,

The serial number for January 1, 2008 is 39448 because it is 39447 days before January 1, 1900.

Description

￭If the two date parameters are numbers, DAYS uses EndDate–StartDate to calculate the number of days between the two dates.

￭If any of the date parameters are text, the parameter will be treated as DATEVALUE(date_text) and the integer date will be returned instead of the time component.

￭If the date parameter is a numeric value outside the valid date range, DAYS returns the #NUM! error value.

￭If the date argument is a valid date that cannot be parsed as a string, DAYS returns the #VALUE! error value.

Example

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-DAYS-han-shu.html