Monthly Archives: April 2019

The YEAR Function

Kornilios Ampatzis/ April 25, 2019/ Functions

It returns the year of a date, represented by a serial number. The year is given as an integer ranging from 1900 to 9999.

The MONTH Function

Kornilios Ampatzis/ April 25, 2019/ Functions

It returns the month of a date, represented by a serial number. The month is given as an integer ranging from 1 to 12.

The DAY Function

Kornilios Ampatzis/ April 25, 2019/ Functions

It returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31.

The NOW Function

Kornilios Ampatzis/ April 25, 2019/ Functions

It returns the serial number of the current date and time.

The DATE Function

Kornilios Ampatzis/ April 25, 2019/ Functions

It combines three separate values to form a date and returns that date.

The ISERROR Function

Kornilios Ampatzis/ April 25, 2019/ Functions

It returns TRUE if the formula you specify leads to an error. If there is no error in the formula ISERROR returns FALSE.

The IFERROR Function

Kornilios Ampatzis/ April 25, 2019/ Functions

It returns a value you specify if a formula leads to an error. If there is no error in the formula IFERROR returns its result. It is part of the logical functions of Excel.

The NOT Function

Kornilios Ampatzis/ April 25, 2019/ Functions

It returns the inverse of a logical value. If a logical value is TRUE it returns FALSE and vice versa. It is part of the logical functions of Excel.

The IF Function

Kornilios Ampatzis/ April 25, 2019/ Functions

It is used to make logical comparisons between two values and return two results. One if the comparison is TRUE and one if the comparison is FALSE. It is part of the logical functions of Excel.