get day from date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
If Weekday(CDate(ans),1) = vbSaturday Then
MsgBox "It's Saturday"
End If
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vba Date$ 1
Calculate week from current day 6
Formatting date as first letter of day only 33
Date format. 1
Finding Date in an overseas format 20
Userform and Text Box Date 2
3 results possible on every day. add up the number of each on each day. 2
Pasting a date to a cell from UserForm 2

Back
Top