Text(month(now()),"MMMM") deosnt work

[BOB]

Hi to all
Weekday(now()) =2
text(weekday(now()),"DDDD")=Monday
Month(now())=2
But text(month(now()),"MMMM") =January. What am I doing wrong?
Thanks!

 

[Arvi Laanemets]

Hi

=TEXT(NOW(),"dddd")
=TEXT(NOW(),"mmmm")

 

[BOB]

Thanks that worksin formula, now how do I put this in code?

Dim mysheet As String
mysheet = (Text(Now(), "MMMM"))
Worksheets(mysheet).Select

Thanks again

 

[Arvi Laanemets]

Hi

Try
mysheet = (Format(Date, "MMMM"))

 

[BOB]

Thanks!

Hi

Try
mysheet = (Format(Date, "MMMM"))