For the result, enter the birth date in cell A1 and paste the formula into cell B1. We'll choose the birth date of 11/04/1983 as a starting point: 35 years old. It's the same as when you use the DATEDIF function on a single cell. =int(YEARFRAC(A1,today()))
The Most Important Takeaways "=LEN(TRIM(cell))-LEN(SUBSTITUTE(cell," ",""))+1" is the formula for counting words in a specific range. To handle arrays, the word count formula is used with the SUM or SUMPRODUCT function. The SUBSTITUTE function replaces all of the cell's spaces with the empty string (").
You may also use the YEARFRAC function in Excel to compute the age (in years) of a date range. The YEARFRAC function returns the number of years between two dates, whereas the INT function only returns the integer portion of the result.
You may also acquire the word count easily using Google Docs. To acquire the word and character count, just copy and paste the text into any blank Google Docs document and hit Control + Shift + C (all at once).
Learner's Ratings
3.8
Overall Rating
50%
21%
6%
8%
15%
Reviews
R
Rishu Baghel
4
sir, can you provide us some table for practice?
S
shams faishal
4
please provide your excel file so it will be easy to learn fast
P
Pintu Kumar
5
improve video quality, because its excel file and the pixel is not good.
J
Juboraj Juboraj
4
Explain details & easy to understand.
M
MD Ayaz Rain
4
powerBI use a data Analysis course in hindi
O
Omkar Jitendra Shinde
4
It is great course
V
Vaibhav Magar
5
I would suggest Absolute reference in 13:30 for the calculation of percentage
Share a personalized message with your friends.