HOW DO I GET THE DAY (MONDAY) FROM A DATE (01/01/2007)
 

HOW DO I GET THE DAY (MONDAY) FROM A DATE (01/01/2007)
 

One way:

Format the cell as "dddd"

In article ,
GRE wrote:

HOW DO I GET THE DAY (MONDAY) FROM A DATE (01/01/2007)
 

Another way: =VLOOKUP(WEEKDAY(F16),H7:I13,2,FALSE) where the date appears in
F16, and the table H7:I13 is a table showing the day number of the week
(Sunday = 1, etc. and the corresponding day)...

But of course this is much more complicated than JE McGimpsey's method....
--
Brevity is the soul of wit.


"JE McGimpsey" wrote:

One way:

Format the cell as "dddd"

In article ,
GRE wrote:

HOW DO I GET THE DAY (MONDAY) FROM A DATE (01/01/2007)
 

Another way:

A1 = 1/1/2007

=TEXT(A1,"ddd") returns Mon
=TEXT(A1,"dddd") returns Monday

Biff

"GRE" wrote in message
...