Today we discuss in this post Excel Date and Time Functions like- Date, Day, Today, Now, Year, Hours, Minutes etc. so please read carefully.
DATE
This function returns the serial number of a particular date.Syntax
DATE(year, month, day)
Example - =Date (2020,04,15)
DATEVALUE
This function converts a date in the form of text to a serial number.Syntax
DATEVALUE(date_text)
Example – suppose date is 01/01/2017 we convert text value, use formula
=Datevalue (01/01/2017) press enter and result display 42736.
DAY
This function converts a serial number to a day of the month.Syntax
DAY(serial_number)
Example – suppose date is 15/04/2020 we convert serial number to a day of the month then use formula =Day (15/04/2020) press enter and result display day is 15.
MONTH
This function converts a serial number to a month.
Syntax
MONTH(serial_number)
Syntax
YEAR(serial_number)
Syntax
DAYS360(start_date, end_date, [method])
Syntax
MONTH(serial_number)
Example – Suppose date is 15-04-2020 and we convert serial number format in month, then written formula = MONTH (15-04-2020) and press enter result display month is 04.
YEAR
This function converts a serial number to a year.Syntax
YEAR(serial_number)
Example – Suppose date is 15-04-2020 and we convert serial number format in year, then written formula = YEAR (15-04-2020) and press enter result display year is 2020.
Excel Logical Category Functions & Errors with ExamplesDAYS360
This function calculates the number of days between two dates based on a 360-day year.Syntax
DAYS360(start_date, end_date, [method])
Example :- in figure.
Excel Logical Category Functions & Errors with Examples
TIME
This function returns the serial number of a particular time.Syntax
TIME(hour,minute,second)
Example - =TIME (12:45:55)
TIMEVALUE
This function converts a time in the form of text to a serial number.Syntax
TIMEVALUE(time_text)
Example – suppose time is 12:45:55 we convert text value, use formula
=Timevalue (12:45:55) press enter and result display 0.531886574.
HOUR
This function converts a serial number to an hour.Syntax
HOUR(serial_number)
Example – suppose time is 12:45:55 we find in this time format is only hours, then put formula = HOUR(12:45:55) and press enter then return this format only hour is 12.
MINUTE
This function converts a serial number to a minute.Syntax
MINUTE(serial_number)
Example – suppose time is 12:45:55 we find in this time format is only minute, then put formula = MINUTE(12:45:55) and press enter then return this format only minute is 45.
SECOND
This function converts a serial number to a second.Syntax
SECOND(serial_number)
Example – suppose time is 12:45:55 we find in this time format is only second, then put formula = SECOND(12:45:55) and press enter then return this format only second is 55.
EOMONTH
This function returns the serial number of the last day of the month before or after a specified number of months.Syntax
EOMONTH(start_date,months)
Example - In figure.
Excel Static Formulas, Average, Averageif, Averageifs
NETWORKDAYS
This function returns the number of whole workdays between two dates.Syntax
NETWORKDAYS(start_date,end_date,holidays)
Example - In figure.
NOW
This function returns the serial number of the current date and time.Syntax
NOW()
Example – You written this function =NOW() and press enter result display current date and time of your system.
TODAY
This function returns the serial number of today's date.Syntax
TODAY( )
Example – You written this function =TODAY() and press enter result display current date of your system.
WEEKDAY
This function converts a serial number to a day of the week.Syntax
WEEKDAY(serial_number,return_type)Example - In figure.
WEEKNUM
This function converts a serial number to a number representing
where the week falls numerically with a year.
Syntax
WEEKNUM(serial_num,return_type)
Example – Weeknum show weekday of year suppose today 15-04-2020. We find week number, then press function
= WEEKNUM(15-04-2020) and press enter result display 16. means weekday is 16.
WORKDAY
This function returns the serial number of the date before or aftera specified number of workdays
Syntax
WORKDAY(start_date,days,holidays)
NOW
This function returns the serial number of the current date and time.Syntax
NOW()
Example – You written this function =NOW() and press enter result display current date and time of your system.
TODAY
This function returns the serial number of today's date.Syntax
TODAY( )
Example – You written this function =TODAY() and press enter result display current date of your system.
WEEKDAY
This function converts a serial number to a day of the week.Syntax
WEEKDAY(serial_number,return_type)Example - In figure.
Conclusion
I hope you understand Excel Date and Time Functions like- Date, Day, Today, Now, Year Hours, Minutes etc. If any questions or comments please ask me.
Also Read
0 टिप्पणियाँ
Please Submit Own Valuable Comments For This Post