Page 31 - TP-Play_V-2.0_Book-6
P. 31

Date and Time Functions


                  Functions                          Purpose                               Example
                                                                                 Input: =TODAY()
            TODAY()                It returns the current date.
                                                                                 Output: 7/23/2019

                                                                                 Input: =MONTH(TODAY())
            MONTH(TODAY())         It returns the current month.
                                                                                 Output: 7
                                                                                 Input: =YEAR(TODAY())
            YEAR(TODAY())          It returns the current year.
                                                                                 Output: 2019
                                                                                 Input: =DAY(TODAY())
            DAY(TODAY())           It returns the current day.
                                                                                 Output: 23

                                   It returns the current  system  date and      Input: = NOW()
            NOW()
                                   time.                                         Output: 21-05-2020 11:24
                                                                                 Input: = HOUR(NOW())
            HOUR(time)             It returns the hour from a given time.
                                                                                 Output: 11
                                                                                 Input: MINUTE(NOW())
            MINUTE(time)           It returns the minutes from a given time.
                                                                                 Output: 24


            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.
                                                                                          Using TODAY function
            Step 3   Type =MONTH(TODAY()) function in the cell and press the
                    Enter 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



             Tech


               Funda


                                  The common functions like SUM, AVERAGE, MAX, MIN,
                                can also be used by using the down arrow of the AutoSum
                                command.
                                 To use other functions click on More Functions option.





                                                                                Formulas and Functions       31
   26   27   28   29   30   31   32   33   34   35   36