Page 46 - TP_Pluse_V2.2_Class_6
P. 46
Step 3: Press the Enter key from the keyboard.
Using MAX function
When you press the Enter key, the maximum marks appear in the cell G3. Using the Auto Fill feature,
find the maximum marks of each student. Similarly, we can find the minimum marks by using the
MIN() function.
Date and Time Functions
Functions Purpose Example
Input: =TODAY()
TODAY() It returns the current date.
Output: 7/23/2024
Input: =MONTH(TODAY())
MONTH(TODAY()) It returns the current month.
Output: 7
Input: =YEAR(TODAY())
YEAR(TODAY()) It returns the current year.
Output: 2024
Input: =DAY(TODAY())
DAY(TODAY()) It returns the current day.
Output: 23
Input: = NOW()
NOW() It returns the current system date and time.
Output: 7/23/2024 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
Let us use the date functions in Excel by performing the
following steps:
Step 1: Type =TODAY() in the cell.
Step 2: Press the Enter key from the keyboard.
When you press the Enter key, the current date appears in
the cell.
Using TODAY function
44 Plus (Ver. 2.2)-VI

