Date and Time Functions
DATE function
Adds dates in the default format MM/dd/yyyy.
DATEDIF function
Returns the difference between two date values based on the specified interval (unit).
DATEVALUE function
Returns a serial number of the specified date.
DAY function
Returns the day (a number from 1 to 31) of the date given in the numerical format.
DAYS function
Returns the number of days between two dates.
DAYS360 function
Returns the number of days between two dates based on a 360-day year using the US or European calculation method.
EDATE function
Returns the serial number of the date which comes the indicated number of months before or after the specified date.
EOMONTH function
Returns the serial number of the last day of the month that comes the indicated number of months before or after the specified start date.
HOUR function
Returns the hour (a number from 0 to 23) of the time value.
ISOWEEKNUM function
Returns the ISO week number of the year for a given date, a number between 1 and 54.
MINUTE function
Returns the minute (a number from 0 to 59) of the time value.
MONTH function
Returns the month (a number from 1 to 12) of the date given in the numerical format.
NETWORKDAYS function
Returns the number of work days between two dates excluding weekends and dates considered as holidays.
NETWORKDAYS.INTL function
Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days.
NOW function
Adds the current date and time to your spreadsheet in the format MM/dd/yy hh:mm.
SECOND function
Returns the second (a number from 0 to 59) of the time value.
TIME function
Adds a particular time in the selected format (hh:mm tt by default).
TIMEVALUE function
Returns the serial number of a time.
TODAY function
Adds the current day in the format MM/dd/yy.
WEEKDAY function
Determines which day of the week the specified date is.
WEEKNUM function
Returns the number of the week the specified date falls within the year.
WORKDAY function
Returns the date which comes the indicated number of days before or after the specified start date excluding weekends and holidays.
WORKDAY.INTL function
Returns the date before or after a specified number of workdays with custom weekend parameters.
YEAR function
Returns the year (a number from 1900 to 9999) of the date given in the numerical format.
YEARFRAC function
Returns the fraction of a year represented by the number of whole days from start-date to end-date calculated on the specified basis.