Page 35 - Digicode_AI_class_6
P. 35
3 Type =AVERAGE(B3:F3) function to find
the average of marks and press the Enter key.
When you press the Enter key, the average of the marks appears in cell I3. Using the AutoFill
feature, we can calculate the average of the marks of each student.
Date and Time Functions
Functions Purpose Example
Input: =Today()
Today() It returns the current date.
Output: 7/23/2022
Input: =MonTh(Today())
MonTh(date) It returns the month of the given date.
Output: 7
Input: =YEAR(TODAY())
YEAR(date) It returns the year of the given date.
Output: 2022
Input: =DAY(TODAY())
DAY(date) It returns the day of the given date.
Output: 23
It returns the current system date and Input: = NOW()
NOW()
time. Output: 21-05-2022 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
Formulas and Functions in Excel 33

