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

