View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default Day / Date Formula

=a1
and format it as: dddd

or just format A1 and give that a nice format:
mm/dd/yyyy* dddd



Neil M wrote:

Is there an formula to automatically display the "day of the week" in cell A2
based on a date entered in cell A1? I have one now but it is very long and am
trying to shorten it.

NeilM


--

Dave Peterson