Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

day of the week

Status
Not open for further replies.
bencnu

bencnu

Technical User
Nov 3, 2003
34
US
Is there a way to find out the current day of the week using excel or vba?
 
Sort by date Sort by votes
Here are two:
[blue]
Code: 
  =WEEKDAY(NOW())
[/color]
and
[blue]
Code: 
  =TEXT(NOW(),"dddd")
[/color]
Look in the help file for details.

 
Upvote 0 Downvote
awesome, exactly what i was looking for
THANX!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Helpful tip
Calculate Week Number - Week in Month - Holidays
Replies
0
Views
355
remeng
remeng
EliseFreedman
  • Locked
  • Question
booking tool - all day time slots
Replies
3
Views
643
Andrzejek
Andrzejek
morechocolate
  • Locked
  • Question
run-tune error 3704 operation is not allowed when the object is codes: I don't think so.
Replies
7
Views
1K
morechocolate
morechocolate
Katto
  • Locked
  • Question
VBA permutation of arrays
2
Replies
22
Views
949
Katto
Katto
huiettcm
  • Locked
  • Question
Catching the Mouse Click Error in Modal User Form
Replies
1
Views
435
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top