Getting day of week from Date ()

[InkyRich]

Hello,
Can anybody tell me how I can get the system DAY of the week from the Date() or Day() or Now() function please.
Regards
Inky

A fool and his money are soon parted - so you might as well send it to me!

 

[HarleyQuinn]

You can use a combination of the Weekday() and WeekDayName() functions. Something along the lines of:

MsgBox WeekdayName(Weekday(Date, vbUseSystem))

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[InkyRich]

Thanks Harley, problem solved.
Very much appreciated



A fool and his money are soon parted - so you might as well send it to me!

 

[HarleyQuinn]

You're welcome, glad I could help

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.