day/date

  • Thread starter Thread starter daved
  • Start date Start date
D

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
 
Hi
simply use a formula like
=A1
and format this cell with the custom format "DDDD"

or use something like
=TEXT(A1,"DDDD")
 
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.
 
Back
Top