get day of week from date?

  • Thread starter Thread starter lalani
  • Start date Start date
L

lalani

I'm trying to find a way to return the day of week (mon-fri) from a
date.

Additionally, is there vb code or a formula to shade cells if they are
certain days (such as sat/sun)?

TIA
 
I'm trying to find a way to return the day of week (mon-fri) from a
date.
Click to expand...

See WEEKDAY function in online help.
Additionally, is there vb code or a formula to shade cells if they are
certain days (such as sat/sun)?
Click to expand...

See conditional formatting in online help.
 
One way:

A1: 10 December 2003
A2: = A1 ===> Wed

when you format A2 with Format/Cells/Number/Custom ddd

For shading, take a look at Conditional formatting in XL Help. One
way:

CF1: Formula is =WEEKDAY(A1,3)>=5
 
Back
Top