View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Display Monday or Thursday

Format cell with date therein for Custom m/d/yyyy, (dddd)

Vaya con Dios,
Chuck, CABGx3




"Deb" wrote:

How do I display Monday or Thursday?


I have a column with the dates listed on the left a, on the right I'm
attemtping to display either Monday or Thursday.

3/16/2007 display 03/19/2007 (Monday)
2/10/2007 display 02/12/2007 (Monday)
4/3/2007 display 04/05/2007 (Thursday)

Thanks for your assistance