Time & Date

Scripting Formulas Time & Date
  • TIME.DATE — Converts numbers for a year, a month, and a day into a Date object which can be used with formulas.
  • TIME.DATEVALUE — Converts text into a Date object. Natural language is supported for date formats, like "Today" or "Last Year".
  • TIME.DAY — Returns the day for a datetime value as a number 1-31.
  • TIME.DAYS — Counts the real number of days between two dates.
  • TIME.DAYS360 — Counts the number of days between two dates using a 360-day calendar. This formula is generally used for financial calculations: you may be looking for TIME.DAYS instead.
  • TIME.FORMAT — Formats the datetime value according to the flags given in the string format.
  • TIME.HOUR — Returns the hour for a datetime value as a number 0-23.
  • TIME.IS_LEAPYEAR — Checks whether the datetime value is a leap year.
  • TIME.MINUTE — Returns the minute for a datetime value as a number 0-59.
  • TIME.MONTH — Returns the month for a datetime value as a number 1-12.
  • TIME.MONTHDAY — Returns the day of the month for a datetime value as a number 1-31.
  • TIME.SECOND — Returns the second for a datetime value as a number 0-59.
  • TIME.TODAY — Returns a date object for the current day.
  • TIME.WEEKDAY — Returns the day of the week for a datetime value as a number 0-6.
  • TIME.YEAR — Returns the year of a datetime value as a number.
  • TIME.YEARDAY — Returns the day of the year for a datetime value as a number 1-366.
  • TIME.YEARFRAC — Returns the number of years, including fractional years, between two dates using a specified day count convention.