Page 458 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

TASK 10: Applying DAYS360 Function
The DAYS360 function calculates the difference between two dates using a 360-day year, assuming each month
has 30 days.
Syntax of DAYS360 function:
=DAYS360(start_date, end_date, [method])

Note: Method is an optional argument to specify the day-count method. TRUE means the function
counts European method and FALSE means the method will be the US method. The default is
FALSE.

TASK 11: Applying EDATE Function

The EDATE function adds or subtracts a specified number of months to a given date and returns the resulting
date.

Syntax of EDATE function:
=EDATE(start_date, months)

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