Unit 4.  Formulas and Functions (III)

 Date and Time Funtions

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 Exercises about dates and time functions .
 Pag. 4.3
 Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.