Page 456 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

TASK 7: Applying WEEKDAY Function
The WEEKDAY function returns the day of the week for a given date and returns it as a numeric value.

Syntax of WEEKDAY function:
=WEEKDAY(date, [return_type])

TASK 8: Using WEEKNUM Function

The WEEKNUM function calculates the week number of a given date based on a specified numbering system.
Syntax of WEEKNUM function:
=WEEKNUM(date, [return_type])
The WEEKNUM function can be used in two different ways based on return type:

Way 1: Week 1 specifies the week which contains January 1st;
Way 2: Week 1 is the week that contains the first Thursday of the year.

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