Date & Time Functions in Excel

Date functions in Excel

DATE:-

1. NOW (): -  It gives the current date and time of the Function Computer.

=NOW()
OUT PUT- 10/20/2012 19:16

2. DAY (): -  This function removes the day from DATE.

Syntax:- day(date)
Example=day(22/7/2016)
Output=20

3. MONTH (): -  This function extracts the month from DATE.

Syntax:- month(date)
Example= month (10/20/2011)
Output=10

4. year (): -  This function extracts the year from DATE.

Syntax:- year(date)
Example= year (10/20/2011)
Output= 2011

5. Today (): -  It gives the function current date output.

=today()
Output:- 10/20/2011

6. Date (): -  This function converts the given numbers into dates.

Syntax:- date(year,month,day)
Example:- date(2011,22,10)
Output= 22/10/211

Time Functions in Excel

1. Time (): - This function changes the given hour, minute, second into time.

Syntax:- Time(hour,minute,second)
Example:- Time(4,30,10)
Output:- 4:30 AM

2. Second (): -  This function returns the output from the given time in seconds.

Syntax:- Second(Time)
Example:- Second(4:30)
Output:- 10

3. Minute (): -  This function returns the minutes output from the given time.

Syntax:- minute(Time)
Example:- minute (4:30)
Output:- 30

4. Hour (): -  This function gives the hour output from the given time.

Syntax:- hour(Time)
Example:- hour(4:30)
Output:- 4

About Admin MC3

This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.

Related Post