Why is this not working?

[Assamita]

Format(DateAdd("m", -1, Date),"[$-409]mmmm") returns "agosto", which is spanish (it should be english):

How do I make the first letter upper case anyway?
Thank you

 

[VBE313]

what are you trying to accomplish?

 

[Assamita]

To get the previous month (now August) in english. Hence the [$-409]

 

[Fluff]

How about

With WorksheetFunction
   MsgBox .Text(.EDate(Date, -1), "[$-409]mmmm")
End With

 

[Assamita]

That did the job, thank you

 

[Fluff]

You're welcome & thanks for the feedback.