Contents
An Introduction to Excel Functions
Financial Functions
Date and Time Functions
Math and Trigonometry Functions
Statistical Functions
Lookup and Reference Functions
Database Functions
Text Functions
Logical Functions
Information Functions
Engineering Functions
Cube Functions
Add-In and Automation Functions
|
 |
 |
 |
|
Date and Time Functions
Function |
Description |
Syntax |
||
DATE |
Returns the serial number of a particular date |
(year,month,day) |
||
DATEVALUE |
Converts a date in the form of text to a serial number |
(date_text) |
||
DAY |
Converts a serial number to a day of the month |
(serial_number) |
||
DAYS360 |
Calculates the number of days between two dates based on a 360-day year |
(start_date,end_date,method) |
||
EDATE |
Returns the serial number of the date that is the indicated number of months before or after the start date |
(start_date,months) |
||
EOMONTH |
Returns the serial number
of the last day of the month before or after a specified number of months |
(start_date,months) |
||
HOUR |
Converts a serial number to
an hour |
(serial_number) |
||
MINUTE |
Converts a serial number to
a minute |
(serial_number) |
||
MONTH |
Converts a serial number to
a month |
(serial_number) |
||
NETWORKDAYS |
Returns the number of whole workdays between two dates |
(start_date,end_date,
holidays) |
||
NOW |
Returns the serial number of the current date and time |
( ) |
||
SECOND |
Converts a serial number to
a second |
(serial_number) |
||
TIME |
Returns the serial number of a particular time |
(hour,minute,second) |
||
TIMEVALUE |
Converts a time in the form of text to a serial number |
(time_text) |
||
TODAY |
Returns the serial number of today’s date |
( ) |
||
WEEKDAY |
Converts a serial number to a day of the week |
(serial_number,return_type) |
||
WEEKNUM |
Converts a serial number to a number representing where the week falls numerically within
a year |
(serial_num,return_type) |
||
WORKDAY |
Returns the serial number of the date before or after a specified number of workdays |
(start_date,days,holidays) |
||
YEAR |
Converts a serial number to
a year |
(serial_number) |
||
YEARFRAC |
Returns the year fraction
representing the number of whole days between start_date and end_date |
(start_date,end_date,basis) |
| Acknowledgments & Disclaimer |
Tags
No one has tagged this page yet... Be the first.. Log in using the link below and return to add your tag
