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
   84   85   86   87   88   89   90   91   92   93   94