Page 28 - Trackpad_ipro 4.1_Class8
P. 28

Date and Time Functions


                       Function                           Purpose                                 Example

                                                                                         Input: =TODAY()
                        TODAY()        Returns the current date
                                                                                         Output: 6/18/2024
                                                                                         Input: =MONTH(TODAY())
                     MONTH(Date)       Returns the current month
                                                                                         Output: 6

                                                                                         Input: =YEAR(TODAY())
                      YEAR(Date)       Returns the current year
                                                                                         Output: 2024

                                                                                         Input: =DAY(TODAY())
                       DAY(Date)       Returns the current day
                                                                                         Output: 18
                                                                                         Input: = NOW()
                        NOW()          Returns the system's current date and time
                                                                                         Output: 6/18/2024 11:24
                                       Returns the hour from the system's current  Input: = HOUR(NOW())
                      HOUR(time)
                                       time                                              Output: 11

                                       Returns the minutes from the system's             Input: = MINUTE(NOW())
                     MINUTE(time)
                                       current time                                      Output: 24

                  To use the date functions in Excel, follow these steps:


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


















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


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




                    26     iPro (Ver. 4.1)-VIII
   23   24   25   26   27   28   29   30   31   32   33