View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Redan Redan is offline
external usenet poster
 
Posts: 8
Default Excel Date Issue

Hi,

I am using Excel 2007 on PC running Windows Vista Ultimate (in french) and
I'd like to return the last month in english instead of french.

strLastMonth = Format(DateAdd("m", -1, Date), "mmmm")

When running the code below, I get "octobre" (in french) and I want to get
"october" no matter what is the language of the pc I'm running my excel
sheet on.

Thanks in advance!