| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Type in m/d/y in one column and have day automatically in next col
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Type in m/d/y in one column and have day automatically in next col
Hi,
Please uase the weekday() function. Explained in Excel's help menu -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Big Building 2008" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Type in m/d/y in one column and have day automatically in next col
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 --- "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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Type in m/d/y in one column and have day automatically in next col
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. -- Thanks, Shane Devenshire "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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| chart type automatically goes to Template | Charts and Charting in Excel | |||
| Type data in one cell - and it automatically populates another cel | Excel Worksheet Functions | |||
| how to type in 1 workbook & automatically insert in another book? | Excel Worksheet Functions | |||
| Excel - I type 9-6 in cell and it automatically changes to 9 June | New Users to Excel | |||
| I type same words and it will not automatically repeat the word | Excel Discussion (Misc queries) | |||
Linear Mode
