If Month?

  • Thread starter Thread starter RJJ
  • Start date Start date
R

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?
 
RJJ said:
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?
Click to expand...


=TEXT(TODAY(),"mmmm")
 
RJJ said:
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?
Click to expand...


=TEXT(TODAY(),"mmmm")
 
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
 
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
 
=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
Click to expand...
 
=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
Click to expand...
 
Try this:

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


RJJ said:
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
Click to expand...
 
Try this:

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


RJJ said:
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
Click to expand...
 
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
 
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
 
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.
 
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.
 
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
 
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
 
Back
Top