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.

 

© aulaClic. All rights reserved. Reproduction in any form whatsoever is prohibited.
November-2005.