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.