Page 89 - PlusGPT_V2.1_C7_Flipbook
P. 89
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
Let us use the date functions in Excel 2016 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.
Step 3: Type =MONTH(TODAY()) function in the cell and press the Enter Using TODAY function
key from the keyboard.
The month of the current date will appear. 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 MONTH function
Let’s CatCh uP
Write the output of the following:
1. =MIN (5,7,8) _____________ 2. =AVERAGE(12,3,6) _____________
3. =TODAY() _____________ 4. =COUNT(4,8,12) _____________
Let’s BaCk-uP
A cell or a range of cells that you want to use in your calculation is called reference.
Formulas in Excel 2016 begin with an equal to (=) sign.
Excel calculates consecutive operators with the same level of precedence from left to right.
Excel 2016 allows users to create custom formulas to perform calculations on the data.
A cell reference is a cell address that can be used in a formula to denote a specific cell.
A group of selected cells is called a range.
Functions are pre-defined formulas in Excel to perform simple and complex calculations.
Different categories of functions are Statistical functions, Mathematical functions, Logical
functions, Text functions and Date and Time functions.
Formulas and Functions 87

