Page 36 - CG_v2.1_flipBooks_class_6
P. 36

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
                           command.
                           To use other functions, click on the More Functions option.






                       34    Computer Genius (V2.1)-VI
   31   32   33   34   35   36   37   38   39   40   41