Description:
Get the number of days of the year, quarter or month to which the specified date belongs.
Syntax:
days(dateExp)
Note:
The function gets the number of days of the year, quarter or month to which the specified date dateExp belongs.
Parameter:
|
dateExp |
A date or a date string of standard format |
Option:
|
@q |
Get the number of days of the quarter to which the specified date belongs |
|
@y |
Get the number of days of the year to which the specified date belongs By default, get the number of days of the month to which the specified date belongs |
|
@o |
Get an integer according to the specified date |
Return value:
Integer
Example:
|
|
A |
|
|
1 |
=days(datetime("19800227","yyyyMMdd")) |
29 |
|
2 |
=days (datetime("2006-01-15 10:20:30")) |
31 |
|
3 |
=days@y(datetime("19800227","yyyyMMdd")) |
366 |
|
4 |
=days@q(datetime("2006-01-15 10:20:30")) |
90 |
|
5 |
=days@o(date(“2022-12-12”)) |
20332 |