day/date

[daved]

I have a file that has numerous dates, (for example - 10/27/2003) and
would like to determine the weekday associated with each date (in thi
example, 10/27/2003 is a Monday) . Does excel have a function o
formula that would allow me to convert the dates in the file to th
weekday. Thanks

 

[Frank Kabel]

Hi
simply use a formula like
=A1
and format this cell with the custom format "DDDD"

or use something like
=TEXT(A1,"DDDD")

 

[Daniel.M]

Hi,

Check the Weekday function. It returns a number from 1 to 7 (or 0 to 6 in some
instances) corresponding to what you might need.

If it's a formatting issue, Frank has already answered.

Regards,

Daniel M.