Page 48 - C_GPT _V4 _class_6
P. 48
Let us use the logical functions in Excel. Perform the following steps to use the logical functions:
Type the given
1 data in the Excel
worksheet.
2 Type =MAX(B3:F3) function in the cell G3 to find
the maximum marks and press Enter key.
When you press the Enter key, the maximum marks appear in cell G3. Using the AutoFill feature, find
the maximum marks for 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 or system's date and time.
Functions Purpose Example
Input: =TODAY()
Today() It returns the current date. Output: 8/3/2024
Input: =MONTH(TODAY())
Month(Today()) It returns the current month.
Output: 8
Input: =YEAR(TODAY())
Year(Today()) It returns the current year.
Output: 2024
It returns the current day from the date Input: =DAY(TODAY())
Day(Today())
specified. Output: 3
Input: = NOW()
NOW() It returns the current system date and time.
Output: 8/3/2024 10:47
Input: = HOUR(NOW())
HOUR(time) It returns the hour from a given time.
Output: 10
Input: = MINUTE(NOW())
MINUTE(time) It returns the minutes from a given time.
Output: 47
You can use the date functions in Excel. To do so, type Date Function
=TODAY() 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() function. Similarly, we can use the YEAR() and DAY()
functions to get the year and day from a date respectively. Using TODAY function
46 CodeGPT (Ver. 4.0)-VI

