get day of week from date?

[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

 

[Harlan Grove]

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

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)?

See conditional formatting in online help.

 

[J.E. McGimpsey]

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