Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto input days of week
Hi, I'm looking to set up a spreadsheet where users enter new months date in cell A1, I have worked out how to auto input dates down the rest of column A but need to fill in days of week in column B. I'm trying to automate process as not all users proficient with excel. It needs to work for any month. Any help would be much appriciated. -- brom0910 ------------------------------------------------------------------------ brom0910's Profile: http://www.excelforum.com/member.php...o&userid=27416 View this thread: http://www.excelforum.com/showthread...hreadid=498071 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto input days of week
Custom format Column B to:
ddd OR dddd Then, in B1, enter =A1 -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "brom0910" wrote in message ... Hi, I'm looking to set up a spreadsheet where users enter new months date in cell A1, I have worked out how to auto input dates down the rest of column A but need to fill in days of week in column B. I'm trying to automate process as not all users proficient with excel. It needs to work for any month. Any help would be much appriciated. -- brom0910 ------------------------------------------------------------------------ brom0910's Profile: http://www.excelforum.com/member.php...o&userid=27416 View this thread: http://www.excelforum.com/showthread...hreadid=498071 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto input days of week
How about something like this: =TEXT(WEEKDAY(A3),"ddd") copied down for all week days or =IF(AND(WEEKDAY(A3)1,WEEKDAY(A3)<7),TEXT(WEEKDAY( A3),"ddd"),"") week days only, no weekend days or simply =A3 with cells formatted as "ddd" HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=498071 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto input days of week
If column A contains a calculated date that Excel recognizes as a date,
you can either... 1. Format the date cells in column A to show the day name as well as the date, or 2. Add a formula to the cells in column B that simply reference column A, then custom format that cell with "ddddd" to show the day only in that column. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto input days of week
On Wed, 4 Jan 2006 14:50:55 -0600, brom0910
wrote: Hi, I'm looking to set up a spreadsheet where users enter new months date in cell A1, I have worked out how to auto input dates down the rest of column A but need to fill in days of week in column B. I'm trying to automate process as not all users proficient with excel. It needs to work for any month. Any help would be much appriciated. In column B: B2: =A2 Format/Cells/Number/Custom Type: dddd --ron |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto input days of week
Thanks guys for your info - tried them all & all worked fine. great job.. -- brom0910 ------------------------------------------------------------------------ brom0910's Profile: http://www.excelforum.com/member.php...o&userid=27416 View this thread: http://www.excelforum.com/showthread...hreadid=498071 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
seperating days of week in a database | Excel Worksheet Functions | |||
Do not show $ per week when days remain < 7 | Excel Discussion (Misc queries) | |||
user defined function | Excel Worksheet Functions | |||
selecting days of week using a formula in spreadsheets | Excel Worksheet Functions | |||
Days of the week. | Excel Worksheet Functions |