Page 34 - TP_Play_V2.1_class6
P. 34
Date and Time Functions
Function Purpose Example
Input: =TODAY()
TODAY() It returns the current date.
Output: 7/23/2019
Input: =MONTH(TODAY())
MONTH(TODAY()) It returns the current month.
Output: 7
Input: =YEAR(TODAY())
YEAR(TODAY()) It returns the current year.
Output: 2019
Input: =DAY(TODAY())
DAY(TODAY()) It returns the current day.
Output: 23
It returns the current system date and Input: = NOW()
NOW()
time. Output: 21-05-2020 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
Let us use the date functions in Excel 2016 by performing the following steps:
Step 1 Type =TODAY() in the cell.
Step 2 Press the Enter key from the keyboard.
When you press the Enter key, the current date appears in the cell.
Using TODAY function
Step 3 Type =MONTH(TODAY()) function in the cell and press the
Enter key from the keyboard.
The month of the current date will appear. 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. Using MONTH function
Tech Funda
The common functions like SUM, AVERAGE, MAX,
MIN, can also be used by using the down arrow of the
AutoSum command.
To use other functions click on More Functions option.
32 Play (Ver. 2.1)-VI

