View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Day of the Week in Excel

Hi,

You posted in programming so do you want

r = Format(Weekday(Range("A1").Value), "dddd")

or on the worksheet

=weekday(a1)

forma as dddd

Mike

"Kat5813" wrote:

If I have a certain date in a field, say June 12, 2008, is there anyway to
do something that will tell me what day of the week that was.