On Thu, 28 Feb 2008 05:49:02 -0800, RyanH
wrote:

I am having an issue with converting the month number to the month
abbreviation.

Below Should Return "Feb", but it is returning "Jan"
1.) ="Jobs Due In or Before "& TEXT(TODAY(NOW()),"mmm")

Below Should Return "Mar", but it is returning "Jan"
2.)="Jobs Due In "& TEXT(MONTH(TODAY())+1,"mmm")

3.)="Jobs Due After " & TEXT(MONTH(TODAY())+1,"mmm")

My computer time is set to Thursday, Feb. 27, 2008. Anybody have any ideas?

Thanks
Ryan

If you are really using formula 1, it will return an error, because
TODAY(NOW()) is not valid.

Did you type these in? IT's always a better idea to copy the actual formula
and paste it in.

Your other problem is that you are not taking into account the fact that Excel
stores dates as serial numbers with 1 = 1 Jan 1900 (or 2 Jan 1904).

So when you execute MONTH(TODAY()) that will return a 2. 2, as a date,
represents 2 Jan 1900; so when you format to show just the month, it, naturally
enough, shows a Jan.

You need to format the date itself, not a derivation of the month of the date.

e.g.

=TEXT(TODAY(),"mmm")

By the way, this is a common mistake to make.
--ron