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/