Page 46 - ModularV1.1 _c6_flipbook
P. 46
Date and Time Functions
Functions 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 MS Excel 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
Using TODAY function
cell.
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 the More Functions
option.
44 Modular (Ver. 1.1)-VII

