Page 219 - CA_165_V2.0_C9_Flipbook
P. 219
Date and Time Functions
We can add the date and time in a cell. There are a number of DATE and TIME functions that can be
used to do this. Some date and time functions are:
Function Result
TODAY() Produces the current date, it contains no argument.
NOW() Produces the current date and time, it contains no argument.
Produces the year of the date which is enclosed within double quotes.
YEAR(“Date”)
Eg. =YEAR(“2009-03-02”) = 2009
Produces the month of the date which is enclosed within double quotes.
MONTH(“Date”)
Eg. =MONTH(“2009-03-02”) = 3
Produces the day of the date which is enclosed within double quotes.
DAY(“Date”)
Eg. =DAY(“2004-03-02”) = 2
Statistical Functions
Statistical Functions take numeric argument(s) and produce result accordingly. Following are the
different type of statistical functions:
Function Result
AVERAGE() Produces the average (mean) of the given arguments.
Eg. =AVERAGE(10;20;30) displays output: 20.
=AVERAGE(A1;A2;A3) displays the average of the cells A1, A2 and A3.
=AVERAGE(A1:A10) displays the average of the cells from the range A1 to A10.
MAX() Produces the largest value from the given range of cells.
Eg. =MAX(10;20;15;25) displays output: 25.
=MAX(A1:A5) displays the largest value from cell A1 to A5.
=MAX(B2:C4) displays the largest value of cells B2, B3, B4,C2, C3 and C4.
MIN() Produces the smallest value from the given set of values/range of cells.
Eg. =MIN(10;20;15;25) displays output: 10.
=MIN(A1;A2;A3) displays the smallest value of cells A1, A2 and A3.
=MIN(B2:C3) displays the smallest value of cells B2, B3, C2 and C3.
COUNT() Produces the number of arguments enclosed in small brackets. It can only count the
numeric entries and ignores the text entries.
Eg. =COUNT(1;2;15;25;3;6) displays output: 6.
=COUNT(A1:A20) displays output: 20 (If all cells i.e., A1 to A20 contains values).
Data Analysis 217

