Converting Number to Month in Text Problem
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
|