Date and Time Functions In Excel

=TODAY()	=NOW()	=DATE()	=DAY()	=MONTH()
=YEAR()	=DAYS360()	=HOUR()	=MUNIT()	=SECOND()
=EOMONTH()	=WORKDAY()	=WORKDAY.INTL()

=TODAY()

This function display current date of a system.

Syntax : =TODAY()

Output: MM/DD/YYYY Shortcut Key: CTRL + ;

=NOW()

This function display both the current date & time of a system.

Syntax : =NOW()

Output: MM/DD/YYYY MM/HH Shortcut Key: CTRL + SHIFT + ;

=DATE()

This function display the number into a date format

Syntax : =DATE(year, month, date)

Ex: DATE(2030, 12, 25) >> Output: 25-12-2030

=DAY()

This function display only the day of a date

Syntax : =DAY(year, month, date)

Ex: DAY(TODAY()) >> Output: 13 (today date is 13-3-2022)

=MONTH()

This function display only the month of a date

Syntax : =MONTH(year, month, date)

Ex: MONTH(TODAY()) >> Output: 3

=YEAR()

This function display only the year of a date

Syntax : =YEAR(TODAY())

Ex: YEAR(TODAY()) >> Output: 2022

=DAYS360()

This function returns the no. of days difference between two days.

Syntax : =DAYS360(start_date, end_date)

Ex: =DAYS360(21-3-2004, TODAY()) >> Output:

=HOUR()

This function returns the hour of the time.

Syntax : =HOUR(serial_number)

Ex: =HOUR(NOW()) >> Output: 18

=MINUTE()

This function returns the minuet of the time.

Syntax : =MINUTE(serial_number)

Ex: =MINUTE(NOW()) >> Output: 6

=SECOND()