View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RyanH RyanH is offline
external usenet poster
 
Posts: 586
Default 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