Page 54 - 2620_Birla Open Mind C-6

When you press the Enter key, the maximum marks appear in the cell G3, 89 in the given example. Using
the AutoFill feature find the maximum marks of each student. Similarly, we can find the minimum marks
by using the MIN() function.

Date and Time Functions

Date and Time functions are used to work on system's date and time.

Functions 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

Input: = NOW()
NOW() It returns the current system date and time.
Output: 21-05-2020 11:24
Input: = HOUR(NOW())
HOUR(time) It returns the hour from current time.
Output: 11

Input: MINUTE(NOW())
MINUTE(time) It returns the minutes from current time.
Output: 24

You can use the date functions in Excel. To do so, type =TODAY() Date Function
in the cell and press the Enter key from the keyboard.

When you press the Enter key, the current date appears in the cell.

We can also give the reference of a cell containing the date to
the MONTH(), YEAR() and DAY() functions to get the month,
year and day from a date respectively.
Using TODAY function

Hintbot

To use the common functions like SUM, AVERAGE, MAX and MIN: click
on the down-arrow of the AutoSum command.
To use other functions: click on More Functions option.

52 Premium Edition-VI