### Latest Post

4/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.

## 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 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 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.

## 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.