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

