Page 29 - iPro_trackGPT_V5_Class8
P. 29

Function                           Purpose                               Example
                                                                                      Input: =YEAR(TODAY())
                 YEAR(date)             It returns the current year.
                                                                                      Output: 2024
                                                                                      Input: =DAY(TODAY())
                 DAY(date)              It returns the current day.
                                                                                      Output: 18

                                        It returns the current  system date  and  Input: = NOW()
                 NOW()
                                        time.                                         Output: 6/18/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

                 To use the date functions, follow the given steps:


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










                 When you press the Enter key, the current date appears in the cell.


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







                 When you press the Enter key, the month of the selected date appears in the cell. 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.





                                   If Excel was a magical library, how would you sort books and filter books you
                                   had read?












                                                                             Spreadsheet—Functions and Charts    27
   24   25   26   27   28   29   30   31   32   33   34