?
Solved

Help with MONTH formula

Posted on 2011-03-10
3
Medium Priority
?
318 Views
Last Modified: 2012-05-11
Hello,

Does anyone know how I can get the =MONTH formula to return ‘mmm’ instead of the number value?
For example instead of ‘1’ I would prefer ‘Jan’. I have attached an example of what I am talking about. I need column B to return the month from column C.

example.xlsx
0
Comment
Question by:vegas86
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 35101101
Hello,

try

=text(Month(C3),"mmm")

or format the cell with the number to custom format

mmm

cheers, teylyn
0
 
LVL 50
ID: 35101175
Of course, you could also just use

=C3

and format the result with

mmm

Then only the month portion of the date will show in the cell, with three letter month abbreviation.

cheers, teylyn
0
 

Author Closing Comment

by:vegas86
ID: 35101177
Works perfectly! thank you Teylyn!!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question