LEN Function in MS Excel

“LEN”

Used for – “LEN” function in MS Excel is used to count the number of characters in a text string or in a cell.

Syntax – LEN(text).

Example – Following example will clear the LEN function:-

	A	B	C	D	E	F	G	H	I
1		EXCEL	WITH	EASE
2	=LEN(“EXCEL WITH EASE”)	=LEN(B1)	=LEN(C1)	=LEN(D1)
3
4
5
6
7

And result you get as under:-

	A	B	C	D	E	F	G	H	I
1		EXCEL	WITH	EASE
2	15	5	4	4
3
4
5
6
7

Note:- The LEN Function counts each character in the text string and if there are any extra spaces are typed in the string it will count them too. So you should be more careful using this function

Read More

DATE Function in MS Excel

“DATE”

Used for – “DATE” function in MS Excel is used make a set of numbers in different column or separately available with us in Microsoft Excel date-time code. In simple words we can say that date function returns the number in the form of date which is known by MS Excel.

Syntax – DATE(Year, Month, day).

Example – Following example will clear the date function:-

	A	B	C	D	E	F	G	H	I
1		Year	Month	Date
2	=DATE(B2,C2,D2)	2017	10	4
3	=DATE(2017,02,28)
4
5
6
7

And result you get as under:-

	A	B	C	D	E	F	G	H	I
1		Year	Month	Date
2	04/10/2017	2017	10	4
3	28/02/2017
4
5
6
7

Note:- The end result will depend upon the date default format of MS Excel or which you have applied to the cell in which you are applying the formula i.e. if your MS excel has default format or you have set the format as DD/MM/YYYY then you will see the result as shown in example but if default format or applied format is MM/DD/YY then result will seems as 10/04/17 for first and 02/28/17 for the second example.

Read More