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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.