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 betweenstart_date
andend_date
."M"
: the number of whole months betweenstart_date
andend_date
."D"
: the number of days betweenstart_date
andend_date
."MD"
: the number of days betweenstart_date
andend_date
after subtracting whole months."YM"
: the number of whole months betweenstart_date
andend_date
after subtracting whole years."YD"
: the number of days betweenstart_date
andend_date
, assumingstart_date
andend_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 :
