simsima_7876
asked on
Get Day name from date
Hi Experts
In VBA how can I get the day name when specifying a date.
So how can I extract the day name from now()
e.g. Monday etc.
Thanks
In VBA how can I get the day name when specifying a date.
So how can I extract the day name from now()
e.g. Monday etc.
Thanks
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Shaun Kline
You can use the Weekday function to get the day of the week from a date, and then use the WeekdayName function to get the name.
Just to be clear for the OP , this is what Shaun Kline suggested:
WeekdayName(Weekday(Now()))
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
