If Month?

[RJJ]

I am struggling with an If=Month formula. In its simplest form, A1:A12 is
January thru December. Cell C1 to show "If month (happens to be May of
course) than show "May". Next month the same cell (C1) will say June, and so
on.

Can't believe I'm struggling to get this to work?

Can you help?

 

[Jacob Skaria]

=TEXT(TODAY(),"mmm")

 

[Jacob Skaria]

=TEXT(TODAY(),"mmm")

 

[Glenn]

I am struggling with an If=Month formula. In its simplest form, A1:A12 is
January thru December. Cell C1 to show "If month (happens to be May of
course) than show "May". Next month the same cell (C1) will say June, and so
on.

Can't believe I'm struggling to get this to work?

Can you help?

=TEXT(TODAY(),"mmmm")

 

[Glenn]

I am struggling with an If=Month formula. In its simplest form, A1:A12 is
January thru December. Cell C1 to show "If month (happens to be May of
course) than show "May". Next month the same cell (C1) will say June, and so
on.

Can't believe I'm struggling to get this to work?

Can you help?

=TEXT(TODAY(),"mmmm")

 

[RJJ]

OK, but how do I include an IF statement? In other words (Apply to cell M4),
If actual month is January, M4 displays the value of R14, If actual month is
February, M4 displays the value of U14, if actual month is March, M4
displays the value of X14, and so on for the 12 months and each month having
the same destination of M4, but one of twelve differnt source possiblities

 

[RJJ]

OK, but how do I include an IF statement? In other words (Apply to cell M4),
If actual month is January, M4 displays the value of R14, If actual month is
February, M4 displays the value of U14, if actual month is March, M4
displays the value of X14, and so on for the 12 months and each month having
the same destination of M4, but one of twelve differnt source possiblities

 

[Glenn]

=CHOOSE(MONTH(TODAY()),R14,U14,X14...

OK, but how do I include an IF statement? In other words (Apply to cell M4),
If actual month is January, M4 displays the value of R14, If actual month is
February, M4 displays the value of U14, if actual month is March, M4
displays the value of X14, and so on for the 12 months and each month having
the same destination of M4, but one of twelve differnt source possiblities

 

[Glenn]

=CHOOSE(MONTH(TODAY()),R14,U14,X14...

OK, but how do I include an IF statement? In other words (Apply to cell M4),
If actual month is January, M4 displays the value of R14, If actual month is
February, M4 displays the value of U14, if actual month is March, M4
displays the value of X14, and so on for the 12 months and each month having
the same destination of M4, but one of twelve differnt source possiblities

 

[Teethless mama]

Try this:

=OFFSET(R14,,MONTH(TODAY())*3-3)

OK, but how do I include an IF statement? In other words (Apply to cell M4),
If actual month is January, M4 displays the value of R14, If actual month is
February, M4 displays the value of U14, if actual month is March, M4
displays the value of X14, and so on for the 12 months and each month having
the same destination of M4, but one of twelve differnt source possiblities

 

[Teethless mama]

Try this:

=OFFSET(R14,,MONTH(TODAY())*3-3)

OK, but how do I include an IF statement? In other words (Apply to cell M4),
If actual month is January, M4 displays the value of R14, If actual month is
February, M4 displays the value of U14, if actual month is March, M4
displays the value of X14, and so on for the 12 months and each month having
the same destination of M4, but one of twelve differnt source possiblities

 

[RJJ]

OK, I tried:

=CHOOSE(MONTH(TODAY()),U108,AB108,AI108,AP108,AW108,BD108,BK108,BR108)

Did not give any error but the value (name) residing in U108 does not appear
in the cell I placed this formula. Also, do I need the TODAY() argument when
I am only looking at the month?

Richard

 

[RJJ]

OK, I tried:

=CHOOSE(MONTH(TODAY()),U108,AB108,AI108,AP108,AW108,BD108,BK108,BR108)

Did not give any error but the value (name) residing in U108 does not appear
in the cell I placed this formula. Also, do I need the TODAY() argument when
I am only looking at the month?

Richard

 

[Glenn]

MONTH(TODAY()) is going to return a number from 1 to 12, depending upon the
current month. Right now, your formula below should return the value in AW108
because May is the 5th month and AW108 is the 5th value listed in your formula.
If you actually want to make this choice based upon a date in a cell, put that
cell reference in the formula in place of "TODAY()".

Also, you likely should have 12 values in the CHOOSE() function, one for each month.

 

[Glenn]

MONTH(TODAY()) is going to return a number from 1 to 12, depending upon the
current month. Right now, your formula below should return the value in AW108
because May is the 5th month and AW108 is the 5th value listed in your formula.
If you actually want to make this choice based upon a date in a cell, put that
cell reference in the formula in place of "TODAY()".

Also, you likely should have 12 values in the CHOOSE() function, one for each month.

 

[RJJ]

Thank You,

I was starting in May and not January. It makes sense to me now and is now
working.

Thanks again for your help and your time.

Richard

 

[RJJ]

Thank You,

I was starting in May and not January. It makes sense to me now and is now
working.

Thanks again for your help and your time.

Richard