In this section we are going to see the functions that are applied to dates and times.
With these we will conclude our instructions in the functions offered by Excel.
We are going to see that in several funtions the argument that is passed to them or the value they return is a "numeric value*". Excel calls numeric value to the number of days gone by since 0 of January 1900 to the date introdouced. That is to say, it takes as the initial date of the system 0/01/1900 and it starts counting from there. In the functions that have mumeric_value_ as argument, you will be able to type a figure or the reference of a cell that contains a date.
| Function |
Description |
See in detail |
| NOW() | Returns
current date and time |
 |
| YEAR(serial_number) | Returns
the year in year format |
|
| DAY(serial_number) | Returns
the day of the month |
|
| DAYS360(start_date;end_date;method) | Calculates
the number of days btween two dates |
|
| WEEKDAY(serial_number;return_type) | Returns
a number between 1 and 7 |
|
| DATE(year,month,day) | Returns
the date in date format |
|
| DATEVALUE(date_text) | Returns
de date in date format |
|
| HOUR(serial_number) | Returns
in figures from 0 to 23 |
|
| TIMEVALUE(time_text) | Converts
a time in text into figures |
|
| TODAY() | Returns
current date |
|
| MONTH(serial_number) | Returns
the number of the month in the range 1(January) to 12 (December) |
|
| MINUTE(serial_number) | Returns
the minute in the range 0 to 59 |
|
| TIME(hour;minute;second) | Converts
hours, minutes and seconds given in figures |
|
| SECOND(serial_number) | Returns
the second in the range 0 to 59 |
|
You
can practise some of these functions in the 
