Page 36 - CG_v2.1_flipBooks_class_6
P. 36
Function Purpose Example
Input: =YEAR(TODAY())
YEAR(date) It returns the year of the given date.
Output: 2024
Input: =DAY(TODAY())
DAY(date) It returns the day of the given date.
Output: 14
It returns the current system date and Input: =NOW()
NOW()
time. Output: 14/07/2024 11:24
Input: =HOUR(NOW())
HOUR(time) It returns the hour from the given time.
Output: 11
It returns the minutes from the given Input: =MINUTE(NOW())
MINUTE(time)
time. Output: 24
Let us use the date and time functions in Excel. To use the date functions, follow the given steps:
1 Type =TODAY() function in the cell and press the Enter key.
2 Type =MONTH(TODAY()) function and press the Enter key.
When you press the Enter key, the current date appears in cell A1 and current month appears in
cell A2.
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.
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.
34 Computer Genius (V2.1)-VI

