EDATE
The EDATE function takes a date as an argument and returns the equivalent date a number of months before or after.
EOMONTH
The EOMONTH ("End Of Month") function receives a date as a parameter and returns the date corresponding to the last day of the month a number of months before or after the specified date.
TIMEVALUE
The TIMEVALUE function converts a text-formatted time to a datetime-formatted time.
DATEVALUE
The DATEVALUE function converts a text-formatted date to a datetime-formatted date.
YEARFRAC
The YEARFRAC function returns the fraction of the year represented by the date range limited by the dates passed as arguments.
OR
The OR function evaluates two conditions and returns the logical value True if either of them is true, or the logical value False otherwise.
AND
The AND function evaluates two conditions and returns the logical value True if both are true, and the logical value False otherwise.
FALSE
The FALSE function returns the logical value False.
TRUE
The TRUE function returns the logical value True.
IF
The IF function checks if a condition is fulfilled and returns one value in a positive case (if the evaluation of the condition returns the logical value True) and another in the negative case (if the evaluation of the condition returns the logical value False).
