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

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!

Hi

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

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"BOB" wrote in message
...
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!

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


"BOB" wrote:

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!

Hi

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

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"BOB" wrote in message
...
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


"BOB" wrote:

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!

Thanks!

"Arvi Laanemets" wrote:

Hi

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

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"BOB" wrote in message
...
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


"BOB" wrote:

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!