| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
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! |
|
#3
|
|||
|
|||
|
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! |
|
#4
|
|||
|
|||
|
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! |
|
#5
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 4 Day Work Week in a formula | Excel Discussion (Misc queries) | |||
| Service work order | Charts and Charting in Excel | |||
| Change Path names in copied work book | Excel Worksheet Functions | |||
| Lookup Doesn't Work | Excel Worksheet Functions | |||
| How do I ensure dates inputted are during the work week? | Excel Worksheet Functions | |||
Linear Mode
