Type in m/d/y in one column and have day automatically in next col

[Big Building 2008]

I would like to enter month/day/year in column A then have the day
automatically come up in column B.
ie: enter 11/31/08 in column A then Friday automatically come up in column B.

Is this possible?

 

[Ashish Mathur]

Hi,

Please uase the weekday() function. Explained in Excel's help menu

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Max]

With a valid real date in A1, eg: 10/31/2008
In B1: =TEXT(A1,"dddd") will return the day: Friday

Note that your posted eg: 11/31/08 is an invalid date
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik

 

[ShaneDevenshire]

Hi,

in B1 enter the formula =A1
then format the cell to DDDD. Choose Format, Cells, Number tab, Custom, and
type dddd into the Type line on the right.

 

[Dave Peterson]

I wouldn't use an extra column of cells for this.

I'd just give the cell a custom format of something like:

dddd dd-mmmm-yyyy

So that one cell showed both the day of week and date.