Months

[Chris Davison]

Evening all,

if in A1 I have "Feb" as text, what's the formula to convert this into a value ?

ie 2 (2 being the second month in a year)

or if I have "Sep" then I want 9, etc etc

Embarrasingly, I couldn't figure it out without using a VLOOKUP and now I can't sleep

many thanks
Chris

 

[Legacy 98055]

=Month(A1)

Tom
This message was edited by TsTom on 2002-04-26 17:40

 

[Chris Davison]

thanks Tom,

this gives me #VALUE error though

The cell just contains "Feb", not "February" or an actual date formatted as MM, just plain old text "Feb"......

*sigh*

 

[Legacy 98055]

Misunderstood you

 

[Chris Davison]

no worries Tom... I appreciate you looking at it....

the "sigh" is at myself for not being able to figure it out, it seems such a silly n simple thing !

 

[Jay Petrulis]

Hi Chris,

There is no straightforward way to do this. Without a lookup, you can use

=MATCH(LEFT(A1,3),{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0)

Good night,
Jay

 

[Chris Davison]

s'cool, thanks Jay