Dim English: English = Array("January", "Febuary", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December")
'Si Date est en décembre alors passer à l'année suivante.
Dim date2 As Date: date2 = DateAdd("m", 1, Date)
Range("A1").Value = "CR " & English(Month(Date) - 1) & " " & Format(Year(Date), "yy") & " to " & English(Month(date2) - 1) & " " & Format(Year(date2), "yy")