Title: Theory / Unimportant / CS / Softw / Website / Google / Sheets / Date
On every note of this deck, unless a note says otherwise:
Page: https://support.google.com/docs/table/25273?hl=en
Language: Sheets
Context: Date

Instruction: DATE(year, month, day)
Returns: Converts a provided year, month, and day into a date. Learn more

Instruction: DATEDIF(start_date, end_date, unit)
Returns: Calculates the number of days, months, or years between two dates. Learn more

Instruction: DATEVALUE(date_string)
Returns: Converts a provided date string in a known format to a date value. Learn more

Instruction: DAY(date)
Returns: Returns the day of the month that a specific date falls on, in numeric format. Learn more

Instruction: DAYS(end_date, start_date)
Returns: Returns the number of days between two dates. Learn more.

Instruction: DAYS360(start_date, end_date, [method])
Returns: Returns the difference between two days based on the 360 day year used in some financial interest calculations. Learn more

Instruction: EDATE(start_date, months)
Returns: Returns a date a specified number of months before or after another date. Learn more

Instruction: EOMONTH(start_date, months)
Returns: Returns a date representing the last day of a month which falls a specified number of months before or after another date. Learn more

Instruction: HOUR(time)
Returns: Returns the hour component of a specific time, in numeric format. Learn more

Instruction: ISOWEEKNUM(date)
Returns: Returns the number of the ISO week of the year where the provided date falls. Learn more

Instruction: MINUTE(time)
Returns: Returns the minute component of a specific time, in numeric format. Learn more

Instruction: MONTH(date)
Returns: Returns the month of the year a specific date falls in, in numeric format. Learn more

Instruction: NETWORKDAYS(start_date, end_date, [holidays])
Returns: Returns the number of net working days between two provided days. Learn more

Instruction: NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
Returns: Returns the number of net working days between two provided days excluding specified weekend days and holidays. Learn more

Instruction: SECOND(time)
Returns: Returns the second component of a specific time, in numeric format. Learn more

Instruction: TIME(hour, minute, second)
Returns: Converts a provided hour, minute, and second into a time. Learn more

Instruction: TIMEVALUE(time_string)
Returns: Returns the fraction of a 24-hour day the time represents. Learn more

Instruction: TODAY()
Returns: Returns the current date as a date value. Learn more

Instruction: WEEKDAY(date, [type])
Returns: Returns a number representing the day of the week of the date provided. Learn more

Instruction: WEEKNUM(date, [type])
Returns: Returns a number representing the week of the year where the provided date falls. Learn more

Instruction: WORKDAY(start_date, num_days, [holidays])
Returns: Calculates the end date after a specified number of working days. Learn more

Instruction: WORKDAY.INTL(start_date, num_days, [weekend], [holidays])
Returns: Calculates the date after a specified number of workdays excluding specified weekend days and holidays. Learn more

Instruction: YEAR(date)
Returns: Returns the year specified by a given date. Learn more

Instruction: YEARFRAC(start_date, end_date, [day_count_convention])
Returns: Returns the number of years, including fractional years, between two dates using a specified day count convention. Learn more