Page 46 - ModularV1.1 _c6_flipbook
P. 46

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 MS Excel 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
                                                                                             Using TODAY function
                  cell.

                  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  the  More  Functions
                                       option.



                  44      Modular (Ver. 1.1)-VII
   41   42   43   44   45   46   47   48   49   50   51