Guys,

I'm kind of a dead end with this function I'm trying to make.
The test data is 1/2/2007. If it falls between 1/1/2007 and 1/5/2007. It will display Week1. I've made the code below but its not working.

Anyone knows what's wrong with my code?


Function WeekDays(ByRef Givenday As Date)
If WeekDays = Givenday >= 1/1/2007 and Givenday<= 1/5/2007 Then
WeekDays = "Week1"
End If
End Function