Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 35 - 2632_CodeMind
P. 35

    Function               Purpose                                      Example

                                                                                           Input: =YEAR(TODAY())
                       YEAR(date)             It returns the year of the given date.
                                                                                           Output: 2024

                                                                                           Input: =DAY(TODAY())
                       DAY(date)              It returns the day of the given date.
                                                                                           Output: 14

                                              It returns the current system date and       Input: =NOW()
                       NOW()
                                              time.                                        Output: 14/07/2024 11:24

                                                                                           Input: =HOUR(NOW())
                       HOUR(time)             It returns the hour from the given time.
                                                                                           Output: 11

                                              It returns the minutes from the given        Input: =MINUTE(NOW())
                       MINUTE(time)
                                              time.                                        Output: 24

                      Let us use the date and time functions in Excel. To use the date functions, follow the given steps:

                              1  Type =TODAY() function in the cell and press the Enter key.

                                            2  Type =MONTH(TODAY()) function and press the Enter key.

                      When you press the Enter key, the current date appears in cell A1 and current month appears in
                      cell A2.

                      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.

                          The common functions like SUM, AVERAGE, MAX, and MIN, can
                          also be used by using the down arrow of the AutoSum button.

                          To use other functions, click on the More Functions option.

                           34    Premium Edition-VI

| 30 31 32 33 34 35 36 37 38 39 40 |