I want the day of the week when I insert a date

  • Thread starter Thread starter HT
  • Start date Start date
H

HT

Excel 2003
WindowsXP

I am creating a spreadsheet and inserting many dates. I want to insert the
date and have the day of the week of that particular date appear. Otherwise
I would have to look up years worth of dates.

Is there a way to do this?

Thank you.
 
Right-click on the cell with the date you wish converted to "Weekday" >
Format Cells > NumberTab > Custom > and type dddd in the little window....> ok

Vaya con Dios,
Chuck, CABGx3
 
If a date is in A1, then in B1 put:

=CHOOSE(WEEKDAY(A1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
 
or =TEXT(A1,"dddd")


--
HTH

Bob Phillips

Gary''s Student said:
If a date is in A1, then in B1 put:

=CHOOSE(WEEKDAY(A1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Frid
ay","Saturday")
Click to expand...
 
Thanks guys..another user said to use Format, Cell, Number, Date and click
on the second option that includes the day with the date.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

week numbers 3
Want day of the week when I insert a date 5
Can't change the cell back to blank when there is a date in it. 0
Date recalculates 1
how to insert day of the week 5
Year + week => first date of week 9
45 day payment 2
Excel Message box with days of month & date. 1

Back
Top