USING "IF" STATEMENTS FOR MONTHS OF YEAR(IF 1=JANUARY)

T

Tina

I Have the following if statement in my excel spreadhseet. the only problem
is that I cannot finish out the year with Sept.-Dec. (I get an error that
says the statement is too big) What can I do to make this formula work for
the whole year??

=IF(Date!D2=1,"JAN.",IF(Date!D2=2,"FEB.",IF(Date!D2=3,"MAR.",IF(Date!D2=4,"APR.",
IF(Date!D2=5,"MAY",IF(Date!D2=6,"JUN.",IF(Date!D2=7,"JUL.",IF(Date!D2=8,"AUG."))))))))
 
D

David Biddulph

Either change to excel 2007, or use
=UPPER(TEXT(DATE(1900,Date!D2,1),"mmm"))&"."
 
E

Eva

Hi
Do you have a date there? If the answer is yes I have simple formula
=TEXT(A1,"mmmm") (if in A1 is a date)
click yes if helped
 
B

Bob Phillips

Got manged a bit, should have been

=UPPER(TEXT(VALUE("01-"&D2),"mmm"))

HTH

Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to getting text labels to show up in scatter chart. 0
Need Formula for Calculating Accrued Vacation Time 2
How do I combine 2 data sets using date? 2
Using multiple IF statements 1
table lookup 5
sum of info in a range based on dates 4
Nested IF Statements, Months of Year 4
Help with year to date comparison 4

Top