Page 30 - Trackpad_V1_Book 6_Flipbook
P. 30
1. Which function calculates the maximum value from a given set of
values?
____________________________________________________________
uiz Bee 2. Which operator has the highest order of precedence?
____________________________________________________________
DATE AND TIME FUNCTIONS
Some date and time functions with their examples are given below.
Function Purpose Example
Input: =TODAY()
TODAY() It returns the current date.
Output: 7/23/2019
Input: =MONTH(TODAY())
MONTH(TODAY()) It returns the current month.
Output: 7
Input: =YEAR(TODAY())
YEAR(TODAY()) It returns the current year.
Output: 2019
Input: =DAY(TODAY())
DAY(TODAY()) It returns the current day.
Output: 23
It returns the current system date and Input: =NOW()
NOW()
time. Output: 21-05-2020 11:24
Input: =HOUR(NOW())
HOUR(time) It returns the hour from a given time.
Output: 11
Input: MINUTE(NOW())
MINUTE(time) It returns the minutes from a given time.
Output: 24
For example, TODAY() function:
Subject: Use of AutoSum Command
To use the common functions like SUM,
AVERAGE, MAX and MIN, click on the
down-arrow of the AutoSum command.
Type =TODAY()
in the cell.
Press Enter key, the current date appears in the cell.
28 Trackpad (Version 1.0)-VI

