MONTH() Problem

[calming.insanity]

I am having problems getting the MONTH() function to work. no matter what date i reference, it comes up with january for some reason. Any ideas?

 

[Gerald Higgins]

What data are you inputting between the brackets ?

 

[Norie]

Well I don't see how it would come up with january since that function returns the month number.

What's the exact formula you are using?

 

[calming.insanity]

formula

i am using

=month(b2)

 

[Gerald Higgins]

OK, so what's in B2 ?

 

[Jonmo1]

Why don't you try

=TEXT(B2,"mmmm")

The reason month(b2) fails is because the Like Norie Said, the Month function returns a NUMBER Jan = 1, Feb = 2 etc...

so month(b2) will return a number from 1 - 12.

in excel date language,
1 = Jan 1 1900
2 = Jan 2 1900
3 = Jan 3 1900

etc...
So I'm guessing you have the cell this formula is in formatted as a date. That would make it Januaray probably..

 

[calming.insanity]

thanks

The reason month(b2) fails is because the Like Norie Said, the Month function returns a NUMBER Jan = 1, Feb = 2 etc...

so month(b2) will return a number from 1 - 12.

in excel date language,
1 = Jan 1 1900
2 = Jan 2 1900
3 = Jan 3 1900

that worked awesomely, i had forgotten about that fact....it's been a while since i had to use date info. I usually import excel files into business objects and let it sort it out. it has made me lazy.