• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Date & Time Functions

Date & Time Functions

DATE(year,month,day) Returns the serial number of a particular date.
DATEVALUE(date_text) Converts a date in the form of text to a serial number.
DAY(serial_number) Converts a serial number to a day of the month.
DAYS360(start_date,end_date,method) Calculates the number of days between two dates based on a 360-day year.
HOUR(serial_number) Converts a serial number to an hour.
MINUTE(serial_number) Converts a serial number to a minute.
MONTH(serial_number) Converts a serial number to a month.
NOW() Returns the serial number of the current date and time.
SECOND(serial_number) Converts a serial number to a second.
TIME(hour,minute,second) Returns the serial number of a particular time.
TIMEVALUE(time_text) Converts a time in the form of text to a serial number.
TODAY() Returns the serial number of today's date.
WEEKDAY(serial_number,return_type) Converts a serial number to a day of the week.
YEAR(serial_number) Converts a serial number to a year.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint