LEN Function in MS Excel

LEN Function in MS Excel

No Comments

“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
DATE Function in MS Excel

DATE Function in MS Excel

No Comments

“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.

Amazon

Is this article helpful to you?