Page 454 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

In the format text argument type your preferred formatting.

TASK 3: Fetch Dates

Using DAY Function
The DAY function extracts the day of the month from a given date and returns it as a numeric value.

Syntax of DAY function:
=DAY(date)

TASK 4: Using MONTH Function

The MONTH function extracts the month from a given date and returns it as a numeric value.
Syntax of MONTH function:
=MONTH(date)

439
CITS : IT & ITES - Computer Software Application - Exercise 73