Breaking News
You are here: Home / Notes / SEM-1 / PC Software-I / MS EXCEL Date and time functions

MS EXCEL Date and time functions

Date and time functions

Date and time functions are used to manipulate date and time. Hence results obtained may be a series of numbers which are to be modified and formatted appropriately.

Function Description
DATE() Returns the sequential serial number that represents a particular date.
Syntax =DATE(year, month, day)
Example =DATE(99,8,7)
Output 8/7/99
DATEVALUE() Converts a date in the form of a text to a serial number.
Syntax =DATEVALUE(date-text)
Example =DATEVALUE(“8/12/2008”)=DATEVALUE(“22th august 2008”)
Output (1)  39682(2)  39501

(3)  39634

DAY() Returns the day of the month represented by a serial number. The day is given as an integer ranging from 1 to 31.
Syntax =DAY(serial-number)
Example =DAY(“2/22/99”)=DAY(“15-April-2008”)
Output (1)  22(2)  15
DAY360() Returns the number of days between  two dates based on a 360-day year, consisting of twelve 30-day months.
Syntax =DAY360(start-date, end-date, method)
Example =DAY360(“2/2/98”,”6/3/99”)
Output 121
MONTH() Returns the month of a date represented by a serial number. The months given as an integer, ranging from 1(January) to 12(December).
Syntax =MONTH(serial-number)
Example =MONTH(“15-April-2008”)
Output 4
TODAY() Returns the serial number of the current date.
Syntax =TODAY()
WEEKDAY() Returns the day of the week corresponding to a date. The day is given as an integer ranging from 1(Sunday) to 7(Saturday) by default.
Syntax =WEEKDAY(serial-number, return-type)
Example =WEEKDAY(“2/14/1998”)
Output 7NOTE:

Return type Number return
1 or omitted Number 1(Sunday) through 7(Saturday)
2

Numbers1(Monday) through 7(Sunday)

3

Numbers 0(Monday) through 6(Sunday)

YEAR() Returns the year corresponding to the date. The year is returned as an integer in the range 1900-9999.
Syntax =YEAR(serial-number)
Example =YEAR(“7/5/2008”)
Output 2008
NOW() Return the serial number of the current date and time.
Syntax =NOW()
TIME() Returns the decimal number for a particular time.
Syntax =TIME(hour, minute, second)
Example =TIME(13,25)
Output 1:25 PM
TIMEVALUE() Returns the decimal number of the time represented by a text string. The decimal number is a value ranging from 0(zero) to 0.99999999, representing the times from 0:00:00 to 23:59:59.
Syntax =TIMEVALUE(time-text)
Example =TIMEVALUE(“2:20 AM”)
Output 0.1
HOUR() Returns the hour of a time value. The hour is given as an integer ranging from 0(12:00 AM) to 23(11:00 PM).
Syntax =HOUR(serial-number)
Example =HOUR(“3:30:30 AM”)
Output 3
MINUTE() Returns the minutes  of a time value. The minute is a given as an integer , ranging from 0 to 59.
Syntax =MINUTE(serial-value)
Example =MINUTE(“4:48:00 PM”)
Output 48
=SECOND() Returns the second of a time value. The second is given as an integer in the range 0 to 59.
Syntax =SECOND(serial-number)
Example =SECOND(“4:48: 48PM”)
Output 48

Download Paper Solutions from Below Link

About admin

Scroll To Top