checking what day a date is?
 

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

--
Message posted from http://www.ExcelForum.com

checking what day a date is?
 

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


neowok wrote:

if i have a date say 12-jun-04 is there an easy to to say something like
if this date = a monday then .... if it = tuesday then... etc


---
Message posted from http://www.ExcelForum.com/

checking what day a date is?
 

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

"neowok " wrote in message
...
if i have a date say 12-jun-04 is there an easy to to say something like
if this date = a monday then .... if it = tuesday then... etc


---
Message posted from http://www.ExcelForum.com/

checking what day a date is?
 

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

"neowok " wrote in message
...
if i have a date say 12-jun-04 is there an easy to to say something like
if this date = a monday then .... if it = tuesday then... etc


---
Message posted from http://www.ExcelForum.com/

checking what day a date is?
 

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


"Binzelli" wrote:

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

"neowok " wrote in message
...
if i have a date say 12-jun-04 is there an easy to to say something
like if this date = a monday then .... if it = tuesday then... etc


---
Message posted from http://www.ExcelForum.com/

checking what day a date is?
 

KeepITCool,

That's right ! Better that way.

Leer ik WEER wat van je ;-)

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


"Binzelli" wrote:

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

"neowok " wrote in message
...
if i have a date say 12-jun-04 is there an easy to to say something
like if this date = a monday then .... if it = tuesday then... etc


---
Message posted from http://www.ExcelForum.com/