| function name |
function description |
Syntax |
| DATE |
on behalf of a specific date to return to the series. |
DATE (year, month, day) |
| DATEDIF |
between the two dates calculated the number of days, months or years. |
DATEDIF (start_date, end_date, unit) |
| DATEVALUE |
function DATEVALUE the main functions of the text that the date will be converted into a series. |
DATEVALUE (date_text) |
| DAY |
return to a series of dates that the number of days, using an integer 1-31, said. |
DAY (serial_number) |
| DAYS360 |
in accordance with the algorithm 360 days a year (to 30 days per month, the year a total of 12 months), the difference between the return period of two days. |
DAYS360 (start_date, end_date, method ) |
| EDATE |
to return to a specified date (start_date) before or after the specified number of months of the date of Series a few. EDATE function can be calculated using the issue date and at the same day in January in the maturity date. |
EDATE (start_date, months) |
| EOMONTH |
return to start-date before or after the designation of the last day of the month series. EOMONTH computable function in the last day of the month-specific time series, for securities in terms of the due date. |
EOMONTH (start_date, months) |
| HOUR |
time value to return the number of hours. that is, a range of 0 (12:00 AM) to 23 (11:00 PM) integer between. |
HOUR (serial_number) |
| MINUTE |
time value to return to the minutes. that is, a range between 0-59 integer . |
MINUTE (serial_number) |
| MONTH |
return to series that the date of the month. is between 1 month (January) and 12 (Dec) between the integers. |
MONTH (serial_number) |
| NETWORKDAYS |
parameters to return to start-data and end-data values between the full working day. working days, excluding weekends and holidays specially designated |
NETWORKDAYS (start_date, end_date, holidays) |
| NOW |
return the current date and time corresponding to the series. |
NOW () |
| SECOND |
the number of seconds to return to the time value. to return the number of seconds from 0 to 59 integer between. |
SECOND (serial_number) |
| TIME |
a specific time to return to the small value, TIME function to return to the small value of from between 0 to 0.99999999 value, the representative from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 PM) the time between. |
TIME (hour , minute, second) |
| TIMEVALUE |
return represented by the text string value of the time . from the small numerical value from 0 to 0.999999999, representatives from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 PM) the time between. |
TIMEVALUE (time_text) |
| TODAY |
to return to the series of the current date, serial number Microsoft Excel is used to calculate the date and time of the date - the time code. |
TODAY () |
| WEEKDAY |
to return to a certain date for a few weeks. By default, its value is 1 (Sunday) to 7 (Saturday) between the integers. |
WEEKDAY (serial_number, return_type) |
| WEEKNUM |
return a number, the figures represent the first few weeks a year . |
WEEKNUM (serial_num, return_type) |
| WORKDAY |
to return to a Date (start date) before or after the specified working days between the date of the value of a certain date. working days, excluding weekends and holidays specifically designated. |
WORKDAY (start_date, days, holidays) |
| YEAR |
year to return to a certain date. the return value is between the 1900-9999 round. |
YEAR (serial_number) |
| YEARFRAC |
return between start_date and end_date the number of days accounted for a percentage of the number of days throughout the year. |
YEARFRAC (start_date, end_date, basis) |
