Page 453 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

EXERCISE 73 : Use advanced date functions

Objectives

At the end of this exercise you shall be able to
• use advanced date functions.

Procedure

TASK 1: Change Dates from/to Text

Using DATEVALUE Function
The DATEVALUE function in Excel converts a date represented as text into a serial number that Excel recognizes
as a date.

Syntax of DATEVALUE function:
=DATEVALUE(date_text)

Note: Dates are stored in Excel as consecutive integers, and it is only the formatting of a cell that
permits a number to be shown as a date. All dates are recorded as integers denoting the number of
days from January 1, 1900 (number 1) to December 31, 9999 (number 2958465). You can change the
serial number back to date format by pressing Ctrl+1.

TASK 2: Applying TEXT Function

The TEXT function is used to convert a numeric value, date, or time into a text string with a specified format.
Syntax of TEXT function:

=TEXT(value,format_text)

438