Thread
:
Calculating days of week
View Single Post
#
4
Posted to microsoft.public.excel.programming
Nick Hodge
external usenet poster
Posts: 1,173
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
Reply With Quote
Nick Hodge
View Public Profile
Find all posts by Nick Hodge