From what I read, xl2007 does what you want!

Pete_UK wrote:

One problem, as you state, is that it needs the Analysis ToolPak
add-in. Not everyone will have this installed (why didn't Microsoft
include it within the standard Excel?)

Pete

Epinn wrote:
How about

=TEXT(EDATE(TODAY(),-1),"mmm")

If EDATE function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in.

If you want to go back 3 months, just change "-1" to "-3"

If you want to advance 4 months, just change "-1" to "4"

I like using EDATE to manipulate (plus or minus) months. Does anyone see a problem?

Epinn

"HearSay" wrote in message ...
I have a cell that I would like to display the three letter month minus a
month based on the current day
So today is 09/29/2006, I would like the cell to contain "Aug"

Is this possible.

--

Dave Peterson