Re: Putting Current Month in Text Statement

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Feb 24, 9:00 pm, JE McGimpsey <jemcgimp...@xxxxxxxx> wrote:
In article
<62cc4ac0-fbae-4955-87de-085d2e65d...@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,





 evandavie...@xxxxxxxxx wrote:
On Feb 20, 7:00 pm, JE McGimpsey <jemcgimp...@xxxxxxxx> wrote:
In article
<dd790b4f-7a7e-46f6-9e9f-368f76741...@xxxxxxxxxxxxxxxxxxxxxxxxxxx>,

 evandavie...@xxxxxxxxx wrote:
How can alter the formula so the statement reads, for example, "Fee
Performance for April 38%"  ?

One way:

   ="Fee Performance for "&TEXT(TODAY(),"MMMM")&TEXT((G30/C30)," 0%")

Thank you for providing this answer.  It works for my need to some
degree.  What I failed to include in the description of my problem is
that I have a separate work*** for each month.  This formula is
based on the current date therefore I came up with a work-around so it
can adapted for the monthly work***/reports. Here is what I did
(using the February report as an example): ="Fee Performance for "&TEXT
(DATE(2009,2,1),"MMMM")&TEXT((G30/C30)," 0%").

This works fine except I'd like a formula that is dynamic so I don't
have to manually type in the the date criteria for each monthly
report.

What I am asking for assistance on should be considered a minor
refinement recognizing that there are users with problems much larger
than this.  I suppose I am asking more out of curiosity than anything
else.

Well, the "minor" refinement depends on how you expect XL to figure out
what month the *** represents...

If you have a date in a cell on that *** (say, A1), then

   ="Fee Performance for "&TEXT(A1,"MMMM")&TEXT((G30/C30)," 0%")

is an easy solution.

Otherwise, you'll need to specify how XL is supposed to know...

This worked perfectly for my needs. Thank you.
.

Quantcast