Page 35 - Computer Genius Class 06
P. 35
3 Type =AVERAGE(B3:F3) function to find
the average of marks and press the Enter ey.
When you press the Enter key, the average of the marks appears in cell I3. sing the AutoFill
eature e can calculate the a erage o the mar s o each student.
Date and Time Functions
Functions Purpose Example
I nput: = TO D A Y ( )
TO D A Y ( ) It returns the current date.
O utput: 7 / 2 3 / 2 02 2
I nput: = M O N TH ( TO D A Y ( ) )
M O N TH ( date) It returns the month of the given date.
O utput: 7
Input: =YEAR(TODAY())
YEAR(date) t returns the year o the gi en date.
Output: 2022
Input: =DAY(TODAY())
DAY(date) t returns the day o the gi en date.
Output: 23
It returns the current system date and Input: = NOW()
NOW()
time. Output: 21 2 22 11 2
Input:
time t returns the hour rom the gi en time.
Output: 11
It returns the minutes from the given Input: = MINUTE(NOW())
MINUTE(time)
time.
Output: 24
Formulas and Functions in Excel 33

