View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Nick Hodge Nick Hodge is offline
external usenet poster
 
Posts: 1,173
Default Calculating days of week

J

Do you need a programming response?

Copy your original dates into column B but this time via
FormatCells...Numbercustom type dddd

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"HBYardSale" wrote in message
...
This should be a simple one, but can't find it in any of the help

menus....

In column A, I have a list of dates, like 4-13-04.
In column B, I would like the day of the week to be displayed.

I found this, which returns a "1" for Sunday, "2" for Monday, etc., but

can't
figure out how to get it to automatically display the name of the day.

=+WEEKDAY("4-13-04")

Many thanks in advance!

-- J