Calculating days of week
Assuming the list starts in A2,
In B2 enter "=A1" without the quotes. Format B2 as DDD or DDDD.
HTH
Anders Silven
"HBYardSale" skrev i meddelandet ...
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
|