Google Sheet with Date Functions

DATE

Converts a provided year, month, and day into a date

SYNTAX – DATE(year, month, day)

  • year – The year component of the date.
  • month – The month component of the date.
  • day – The day component of the date.

Example :

DATEDIF

Calculates the number of days, months, or years between two dates.

SYNTAX – DATEDIF(start_date, end_date, unit)

start_date – The start date to consider in the calculation. Must be a reference to a cell containing a date, a function returning a date type, or a number.

end_date – The end date to consider in the calculation. Must be a reference to a cell containing a date, a function returning a date type, or a number.

unit – A string abbreviation for unit of time. For example, “M” for month. Accepted values are “Y”,”M”,”D”,”MD”,”YM”,”YD”.

  • "Y": the number of whole years between start_date and end_date.
  • "M": the number of whole months between start_date and end_date.
  • "D": the number of days between start_date and end_date.
  • "MD": the number of days between start_date and end_date after subtracting whole months.
  • "YM": the number of whole months between start_date and end_dateafter subtracting whole years.
  • "YD": the number of days between start_date and end_date, assuming start_date and end_date were no more than one year apart.

Example :

DATEVALUE

Converts a provided date string in a known format to a date value

SYNTAX – DATEVALUE(date_string)

  • date_string – The string representing the date.
    • Understood formats include any date format which is normally autoconverted when entered, without quotation marks, directly into a cell. Understood formats may depend on region and language settings.

Example :