Try these amendments:
="Jobs Due In or Before "& TEXT(TODAY(),"mmm")
="Jobs Due In "& TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())+1,1),"mmm")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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