N
neowok
if i have a date say 12-jun-04 is there an easy to to say something lik
if this date = a monday then .... if it = tuesday then... et
if this date = a monday then .... if it = tuesday then... et
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
keepITcool
i think this question belongs in excel.worksheetfunctions
if it's indeed a vba question:
select case weekday(MyDate,vbMonday)
case vbSunday
goto Football
case vbMonday
goto Work
case vbSaturday
goto Shopping
end select
keepITcool
< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
if it's indeed a vba question:
select case weekday(MyDate,vbMonday)
case vbSunday
goto Football
case vbMonday
goto Work
case vbSaturday
goto Shopping
end select
keepITcool
< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
B
Binzelli
Hi !
I assume you want to check the day in VBA, not in an Excel formula.
You can use format(Date,"dddd") to give you the name of the day (or "ddd"
for the abbreviated day notation)
Example: format(Now,"dddd") returns Thursday, format(Now,"ddd") returns Th
Good Luck
I assume you want to check the day in VBA, not in an Excel formula.
You can use format(Date,"dddd") to give you the name of the day (or "ddd"
for the abbreviated day notation)
Example: format(Now,"dddd") returns Thursday, format(Now,"ddd") returns Th
Good Luck
B
Binzelli
Hi !
I assume you want to check the day in VBA, not in an Excel formula.
You can use format(Date,"dddd") to give you the name of the day (or "ddd"
for the abbreviated day notation)
Example: format(Now,"dddd") returns Thursday, format(Now,"ddd") returns Th
Good Luck
I assume you want to check the day in VBA, not in an Excel formula.
You can use format(Date,"dddd") to give you the name of the day (or "ddd"
for the abbreviated day notation)
Example: format(Now,"dddd") returns Thursday, format(Now,"ddd") returns Th
Good Luck
K
keepITcool
Binzelli..
your solutions works, BUT using Format(date,"ddd") will give a localized
string... which might be a problem if you have users with different NLS
settings..
(beter zo ;-)
keepITcool
< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
your solutions works, BUT using Format(date,"ddd") will give a localized
string... which might be a problem if you have users with different NLS
settings..
(beter zo ;-)
keepITcool
< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
Binzelli said:Hi !
I assume you want to check the day in VBA, not in an Excel formula.
You can use format(Date,"dddd") to give you the name of the day (or
"ddd" for the abbreviated day notation)
Example: format(Now,"dddd") returns Thursday, format(Now,"ddd")
returns Th
Good Luck
B
Binzelli
KeepITCool,
That's right ! Better that way.
Leer ik WEER wat van je ;-)
That's right ! Better that way.
Leer ik WEER wat van je ;-)
keepITcool said:Binzelli..
your solutions works, BUT using Format(date,"ddd") will give a localized
string... which might be a problem if you have users with different NLS
settings..
(beter zo ;-)
keepITcool
< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >