Latest Post

6/recent/ticker-posts

Excel Date and Time Functions with Example

Today we discuss in this post Excel Date and Time Functions like- Date, Day, Today, Now, Year, Hours, Minutes etc. so please read carefully. 


Excel Date and Time Functions with Example


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)

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 Examples

DAYS360 

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 Date and Time Functions with Example

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 Date and Time Functions with Example


 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.

Excel Date and Time Functions with Example

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.

Excel Date and Time Functions with Example


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 after
a 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.

Excel Date and Time Functions with Example


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 टिप्पणियां