That's happening because the result of:

MONTH(NOW())-3

= 7

In the TEXT function, the 7 is being evaluated as serial date 7 or January 7
1900.

Try this:

=TEXT(30*(MONTH(NOW())-3),"mmmm")

--
Biff
Microsoft Excel MVP


"Dave L" wrote in message
...
I'm trying to write a formula that will take the current month and
subtract 3
from it and then display the full month name. This formula returns a 7 as
expected:
=MONTH(NOW())-3

But when I add the Text function to it so it returns "July" it always
displays "January" no matter what number i subtract:
=TEXT(MONTH(NOW())-3,"mmmm")

I can't just format the cell because this needs to be embedded into
another
formula. How to i make it return the correct name of the month?