Course Content

  • Formulas With Solution(3)

Course Content


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

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere