MS Excel Date Time Functions

Function name

Description

date(year, month, day)

 Return date

month(serial_number)

 Return month from the given date

day(serial_number)

 Return day of the month

hour(serial_number)

 Return hour from the given time

minute(serial_number)

 Return minute from the given time

second(serial_number)

 Return second from the given time

time(hour, minute, second)

 Return time

now()

 Return current date time

today()

 Return current date

weekday()

 Return day of the week

weeknum()

 Return week number in a year

year(serial_number)

 Return year from the given date.

© 2016 - 2022, All Rights are Reserved.