Page 52 - TP_Modular_V2.1_Class7
P. 52

Date and Time Functions


                        Function                           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

                                                                                       Input: =YEAR(TODAY())
                  YEAR(TODAY())          It returns the current year.
                                                                                       Output: 2024
                                                                                       Input: =DAY(TODAY())
                  DAY(TODAY())           It returns the current day.
                                                                                       Output: 23
                                         It returns the current  system  date and      Input: = NOW()
                  NOW()
                                         time.                                         Output: 04-12-2024 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.








                   50       Modular (Ver. 2.1)-VII
   47   48   49   50   51   52   53   54   55   56   57