Page 455 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

TASK 5: Applying YEAR Funcion

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

TASK 6: Utilizing EOMONTH Function

The EOMONTH function finds the last day of the output month based on a specified number of months before
or after a referenced date.
Syntax of EOMONTH function:

=EOMONTH(start_date, months)

440

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