View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Type in m/d/y in one column and have day automatically in next col

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.



Big Building 2008 wrote:

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?


--

Dave Peterson