| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statement with date format
Hi All:
I have the statement below were "Tue" is in date format. That's is the reason the macro doesn't read this field. If ActiveCell.Offset(0, -10) Like "Tue*" And ActiveCell.Offset(0, -12) Like "MB*" Then How could I write this stamentent so that it works? Thanks in advance for your help. Orquidea |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if statement with date format
Hi,
If it's a corrrectly formatted date then you can use weekday If Weekday(ActiveCell.Offset(0, -10) = 3) And ActiveCell.Offset(0, -12) Like "MB*" Then Mike "orquidea" wrote: Hi All: I have the statement below were "Tue" is in date format. That's is the reason the macro doesn't read this field. If ActiveCell.Offset(0, -10) Like "Tue*" And ActiveCell.Offset(0, -12) Like "MB*" Then How could I write this stamentent so that it works? Thanks in advance for your help. Orquidea |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if statement with date format
Mike:
I have the correct date format but when the if statement evaluates the condition, it is considering all days as 3. Would be any extra format I have to do. Thanks, Orquidea "Mike H" wrote: Hi, If it's a corrrectly formatted date then you can use weekday If Weekday(ActiveCell.Offset(0, -10) = 3) And ActiveCell.Offset(0, -12) Like "MB*" Then Mike "orquidea" wrote: Hi All: I have the statement below were "Tue" is in date format. That's is the reason the macro doesn't read this field. If ActiveCell.Offset(0, -10) Like "Tue*" And ActiveCell.Offset(0, -12) Like "MB*" Then How could I write this stamentent so that it works? Thanks in advance for your help. Orquidea |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| How to add date format into if statement? | Excel Worksheet Functions | |||
| How to add date format into if statement? | Excel Discussion (Misc queries) | |||
| Date Format Inside of a SUMIF Statement | Excel Worksheet Functions | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
Linear Mode
