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
simsima_7876Asked:
Who is Participating?
 
MacroShadowCommented:
Format(Now(),"dddd")

Open in new window

0
 
Shaun KlineLead Software EngineerCommented:
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.
0
 
MacroShadowCommented:
Just to be clear for the OP , this is what Shaun Kline suggested:
WeekdayName(Weekday(Now()))

Open in new window

0
 
Gustav BrockCIOCommented:
That won't work in an international environment, except if extended:

    strWeekday = WeekdayName(Weekday(Date), , vbSunday)

So Format is much simpler and easier:

    strWeekday = Format(Date, "dddd")

/gustav
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.