Function: YEAR

Function: YEAR

The Excel YEAR function returns the year from a specified date serial number. In this guide, we’re going to show you how to use this function and also go over some tips and error handling methods. Supported versions All Excel versions Excel YEAR Function Syntax...
Function: MONTH

Function: MONTH

The Excel MONTH function returns the month from a specified date serial number. In this guide, we’re going to show you how to use the this function and also throw in some tips and error handling methods. Supported versions All versions Excel MONTH Function Syntax...
Function: DAY

Function: DAY

The DAY function in Excel returns the day from a specified date number. In this guide, we’re going to show you how to use this function and also include some tips and error handling methods. Supported versions All Excel versions DAY Function in Excel Syntax...
Function: PROPER

Function: PROPER

The PROPER function capitalizes the first letter of each word and converts the remaining letters into lowercase. In this guide, we’re going to show you how to use the this function and also go over some tips and error handling methods. Supported versions All Excel...
Function: LOWER

Function: LOWER

The LOWER function converts a text to lowercase. In this guide, we’re going to show you how to use the this function and also go over some tips and error handling methods. Supported versions All Excel versions Syntax LOWER(text) Arguments text The text you want...
Function: UPPER

Function: UPPER

The UPPER function converts a text into uppercase. In this guide, we’re going to show you how to use this function and cover some tips and error handling methods. Supported versions All Excel versions Syntax UPPER(text) Arguments text The text you want converted to...
Function: IF

Function: IF

The IF function performs a logical test (specified from its first argument), and returns either one of its second or third argument depending on the result of the test. If the test returns TRUE, the result will be the second argument, otherwise it will be the third....
Function: HLOOKUP

Function: HLOOKUP

HLOOKUP function is a lookup and reference function that can search a specific information in a selected table. In this guide, we’re going to show you how to use the HLOOKUP function and also go through some tips and error handling methods. The HLOOKUP searches a...
Function: VLOOKUP

Function: VLOOKUP

VLOOKUP function is a lookup and reference function that can search a specific information in a table. In this guide, we’re going to show you how to use the VLOOKUP function and also add some tips and error handling methods. The VLOOKUP searches a value in the first...