adding day (sunday, Monday) to date

R

RickyDee

I have an ACCESS database that I copied over into EXCEL for ease. Now I have
a date such as 04/08/2005. I'd like to somehow add a column for the day of
the week that this is, or add the day to this particular column and I'll use
a delimiter or something to separate it. In the end, I'd like to have a
separate column for the day.
Thank you,
Rick
[email protected]
 
J

justahelper

You could simply format the same column. If, however, you insist on having
the day in a separate column:
1. insert a column next the the column having the date value
2. insert a formula which simply equates the new column to the original column
3. select the entire new column or the used range in the new column
4. format the cells using custom format with format string "dddddd"
 
B

Bob Phillips

in the adjacent column, add

=TEXT(A1,"dddd")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
R

RickyDee

Sounds like it should work. A couple of eons ago I would have been able to
figure this out. (Sounds too easy).
I may be asking another question, since the brain cells are getting fewer
and further distance apart. What I'm attempting to do is use the information
from my complete database to see which teams (ball games) win mostly on which
days of the week and see if there's a difference large enough to count on.
Thanks again.
Rick D.
 
T

TBee

There are two ways you could do this

1. The simple way.
You could copy your dates to an additional column, select the new
column. Go to the "Format Menu" select "Cells", then select the
"Number" Tab and scroll to "Custom" and select. In the "Type" box,
input "DDDD" (for the weekday) or "DDDD, DD/MM/YYYY" (for the weekday
followed by the date) and then hit "OK".

2. The slightly less simple way.
Using VBA add a module to the spreadsheet and add this function to it

Function DayOfTheWeek(Dates)
DayOfTheWeek = Format(Dates, "DDDD")
End Function

Call the function from your spreadsheet as follows (assuming cell A1
has a date in) "=DayOfTheWeek(A1)"

The second method is better, if you want to combine the day of the week
with other strings.
 
Top