get day from date
 

Hi,

I have a date entered by the user into an input box in the form dd/mm/yy. I
want to be able to tell if that date is on the weekend. Is there a
function/way to say if, for example, 10/10/04 = Sunday?

Many thanks in advance

Greg

get day from date
 

If Weekday(CDate(ans),1) = vbSaturday Then
MsgBox "It's Saturday"
End If

--

HTH

RP

"Greg Billinge" wrote in message
...
Hi,

I have a date entered by the user into an input box in the form dd/mm/yy.
I
want to be able to tell if that date is on the weekend. Is there a
function/way to say if, for example, 10/10/04 = Sunday?

Many thanks in advance

Greg