Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using automatic dates in cells
I have a worksheet and the headers are labeled with the days of the week (Mon
thru Fri) only. The next header row is labeled with the month/day/year. The user set this up whereas just changing the function would change the day of the week to match the date in the row below it. How is this done? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using automatic dates in cells
"shereea_1" wrote: I have a worksheet and the headers are labeled with the days of the week (Mon thru Fri) only. The next header row is labeled with the month/day/year. The user set this up whereas just changing the function would change the day of the week to match the date in the row below it. How is this done? Example: Mon Tue Wed Thu Fri Mon Tue Wed 12/1/2009 12/2/2009 12/3/2009 12/4/2009 12/5/2009 12/8/2009 12/9/2009 12/10 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using automatic dates in cells
If you've got a date in A2, then if in A1 you use
=TEXT(A2,"dddd") you'll get the text Wednesday =TEXT(A2,"ddd") you'll get the text Wed =A2 you can format the cell as ddd or dddd. -- David Biddulph shereea_1 wrote: I have a worksheet and the headers are labeled with the days of the week (Mon thru Fri) only. The next header row is labeled with the month/day/year. The user set this up whereas just changing the function would change the day of the week to match the date in the row below it. How is this done? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using automatic dates in cells
Hi,
Say you have 12/1/2009 in a2 put this in A1 =A2 The format this as DDD with Format|Cells - select Custom and enter DDD Mike "shereea_1" wrote: "shereea_1" wrote: I have a worksheet and the headers are labeled with the days of the week (Mon thru Fri) only. The next header row is labeled with the month/day/year. The user set this up whereas just changing the function would change the day of the week to match the date in the row below it. How is this done? Example: Mon Tue Wed Thu Fri Mon Tue Wed 12/1/2009 12/2/2009 12/3/2009 12/4/2009 12/5/2009 12/8/2009 12/9/2009 12/10 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatic dates | New Users to Excel | |||
How do I switch off automatic formatting (e.g. dates)? | Excel Discussion (Misc queries) | |||
Automatic shading of cells based on dates??? | Excel Worksheet Functions | |||
stop automatic increment of dates | Excel Discussion (Misc queries) | |||
Help with automatic dates | New Users to Excel |