excel function question

  ernieernie 20:29 14 Oct 2010
Locked

I can use the Excel "Month" function to give me a number for the month in any given date: e.g. 1 for January, 2 for February etc. Is there a way to find the name corresponding to a number when using a formula? That is, on finding the number 3, to display March?
ernieernie

  STREETWORK 22:10 14 Oct 2010

Returns the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December).

Syntax:

MONTH(serial_number)

  KremmenUK 07:00 15 Oct 2010

Once you have the number displayed in the cell, right click the cell and select 'Format Cells'

From there select the Number Tab then select 'Custom' and type in MMM or MMMM.

This will change the number to either say Jan or January depending on the number of M's

  VoG II 08:40 15 Oct 2010

Or with a date in A1

=TEXT(A1,"mmmm")

  ernieernie 14:59 15 Oct 2010

Thanks, KremmenPK and VoG for helping
ernieernie

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

30 UK artists have created vibrant posters celebrating Pride London

iPad Pro 10.5in (2017) review

Comment connecter un MacBook à une TV ?