Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking a date/number between two others | Excel Discussion (Misc queries) | |||
Color Code Date Checking | Excel Worksheet Functions | |||
Put todays date in a cell by checking a box!! | Excel Discussion (Misc queries) | |||
Help with Date checking code | Excel Programming | |||
Checking for valid date | Excel Programming |