Page 29 - iPlus_Ver_2.0_class_8
P. 29
Functions Purpose Example
Input: =YEAR(TODAY())
YEAR(TODAY()) It returns the current year.
Output: 2023
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-2023 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
To use the date functions, follow the given steps:
2 Type =MONTH(TODAY()) function and press the Enter key.
1 Type =TODAY() function in the cell and press the Enter key.
When you press the Enter key, the current date appears in the cell.
The month of the current date will appear. We can also give the reference of a cell containing the
date to the MONTH() function. Similarly, we can use the YEAR() and DAY() functions to get the
year and day from a date, respectively.
Quick Byte
The common functions like SUM, AVERAGE, MAX, and MIN, can
also be used by using the down arrow of the AutoSum command.
To use other functions, click on the More Functions option.
27
Spreadsheet—Functions and Charts

