| Name: |
DATE |
| Syntax: |
DATE(<year>, <month>, <day>) |
| Description: |
Returns a date from the year, month and day passed in. |
| Version: |
1.0 |
| Example: |
DATE(2000, 12, 25) Evaluates to 12/25/00 (U.S. format) |
| Name: |
DATEVALUE |
| Syntax: |
DATEVALUE(<text_date>) |
| Description: |
Converts a date in the form of text to a number. |
| Version: |
3.0 |
| Name: |
DAY |
| Syntax: |
DAY(<date>) |
| Description: |
Returns the day of the date passed in. |
| Version: |
1.0 |
| Example: |
DAY(12/25/08) Evaluates to 25 (when dates are in U.S. format) |
| Name: |
HOUR |
| Syntax: |
HOUR(<date>) |
| Description: |
Returns the hour of the date/time passed in. |
| Version: |
1.0 |
| Example: |
HOUR(12/25/08 15:30:00) Evaluates to 15
HOUR(17:45) Evaluates to 17 |
| Name: |
MINUTE |
| Syntax: |
MINUTE(<date>) |
| Description: |
Returns the minute of the date/time passed in. |
| Version: |
1.0 |
| Example: |
MINUTE(12/25/08 15:30:00) Evaluates to 25
MINUTE(17:45) Evaluates to 45 |
| Name: |
MONTH |
| Syntax: |
MONTH(<date>) |
| Description: |
Returns the month of the date passed in. |
| Version: |
1.0 |
| Example: |
MONTH(12/25/08) Evaluates to 12 (when dates are in U.S. format) |
| Name: |
NOW |
| Syntax: |
NOW() |
| Description: |
Returns a date which is the current date and time. |
| Version: |
1.0 |
| Example: |
NOW() May evaluate to 10/9/08 20:00 (U.S. format) |
| Name: |
SECOND |
| Syntax: |
SECOND(<date>) |
| Description: |
Returns the second of the date/time passed in. |
| Version: |
1.0 |
| Example: |
SECOND(12/25/08 15:30:38) Evaluates to 38
SECOND(17:45) Evaluates to 0 |
| Name: |
TIME |
| Syntax: |
TIME(<hour>, <minute>, <second>) |
| Description: |
Returns a time from the hour, minute and second passed in. |
| Version: |
1.0 |
| Example: |
TIME(20, 30, 0) 20:30:00
TIME(15, 45, 30) 15:45:30 |
| Name: |
TIMEVALUE |
| Syntax: |
TIMEVALUE(<text_time>) |
| Description: |
Converts a time in the form of text to a number. |
| Version: |
3.0 |
| Name: |
TODAY |
| Syntax: |
TODAY() |
| Description: |
Returns a date which is the current date at 00:00. |
| Version: |
1.0 |
| Example: |
TODAY() May evaluate to 10/9/08 (U.S. format) |
| Name: |
WEEKDAY |
| Syntax: |
WEEKDAY(<date>) |
| Description: |
Returns the day of the week of the date passed in. Sunday=1, Monday=2 etc. |
| Version: |
1.0.2 |
| Example: |
WEEKDAY(01/01/08)
WEEKDAY(A1) |
| Name: |
WEEKNUM |
| Syntax: |
WEEKNUM(<date>) |
| Description: |
Returns the week number in the year of the date passed in. |
| Version: |
1.0.2 |
| Example: |
WEEKNUM(01/01/08)
WEEKNUM(A1) |
| Name: |
YEAR |
| Syntax: |
YEAR(<date>) |
| Description: |
Returns the year of the date passed in. |
| Version: |
1.0 |
| Example: |
YEAR(12/25/08) Evaluates to 2008. |