How do I add weekdays?

  • Thread starter Thread starter Interesting Ian
  • Start date Start date
I

Interesting Ian

I have a column of dates. How do I get excel to automatically put the
weekday in? I currently have excel 2003. Will I need to update to excel
2007 in order for it to be able to do this?
 
Highlight the column then click on Format | Cells | Number tab. Choose
Custom from the list (near the bottom) and then type this format in
the panel:

dddd dd/mm/yyyy

When you use dddd in the format string Excel will take it that you
mean the full day, whereas ddd will give you Mon, Tue, Wed etc.

If you want the weekday in a separate column, then assuming your dates
are in column A you could put this in a helper column:

=TEXT(A1,"dddd")

and copy down.

Hope this helps.

Pete
 
If the date is showing as something like 12/12/2008 and you want Fri
12/1/2/2008 then use a custom format of ddd dd/mm/yyyy (or ddd mm/dd/yyyy if
you are in the USA). To see Friday (full word) use four d's as in dddd etc.
To see the weekday in the next column use =A1 and format B1 as dddd.
Any help?
best wishes
 
Highlight the column then click on Format | Cells | Number tab. Choose
Custom from the list (near the bottom) and then type this format in
the panel:

dddd dd/mm/yyyy

When you use dddd in the format string Excel will take it that you
mean the full day, whereas ddd will give you Mon, Tue, Wed etc.

Hi,

Thank you! It worked! Mind you, about 15 minutes I just ordered excel
2007. Not because of the weekday issue, but because I'm limited to 65,000
rows in excel 2003. I need more than that.
 
Back
Top