UDF w/ 2 Condition: How?

[japorms]

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

[mrice]

Try

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