Thread: HOW DO I GET THE DAY (MONDAY) FROM A DATE (01/01/2007)
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
  
Posts: 2,574
Default 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:

Reply With QuoteReply With Quote