If Month?
=CHOOSE(MONTH(TODAY()),R14,U14,X14...
RJJ wrote:
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" wrote:
RJJ wrote:
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")
|