Course Content

  • Formula With Solution

Course Content


  • Select the Number option from the drop-down menu.
  • From the Category drop-down menu, choose Custom.
  • In the Type input box, type mmmm.
  • Select OK from the drop-down menu.

Generic formula. =TEXT(date,"mmmm") You can use the TEXT function with a custom number format to retrieve the month name (i.e. January, February, March, etc.) from a date as text.

The MMM Formula is a formula that can be used in Excel to calculate the net present value of an investment. The formula takes into account the current value, future cash flows, and the time period for which these cash flows will occur.

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