Month - result as text not number

[marystewart78]

Hi All,

Using the Month formula to pull out the month from a date - the result is displaying as a number (1 - 12) but I would like this to be displayed as text (Jan - Dec) - can this be done using this formula or is there an alternative formula?

Thanks,

Mary

 

[Brianwarnock]

The only way I can think of doing this is with say VLOOKUp and an array

eg =VLOOKUP(MONTH(A2),Sheet2!A1:B7,2)

You date is in A2 and Shhet 2 a1-a12 contains 1-12 and b1-b12 contains Jan-Dec

Brian

 

[shades]

=TEXT(A2,"mmm")
________
SATIVA STRAINS

 

[Brianwarnock]

Damn, I've used that for days in the past but just forgot about it.

brian

 

[shades]

What??? I never forget anything, George... oh wait, Ralph, um...., no Brian.
________
MARIJUANA VAPORIZER

 

[Brianwarnock]

Had a quiet chuckle at that , thanks for your understanding

Brian