| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display "this week" column headers w/date & day of week?
What I'm trying to create is a sort of calendar that has the 7 days of the
week as the column headers. I want the headers to display the day of the week and the date depending on what week it is. So if it's the week of September 9th, I want A1 to show 9/9/2007 - Sunday, A2 would be 9/10/2007 - Monday, etc. Then, the following week I want the headers to change so that A1 is now 9/16/2007 - Sunday. Of course, this is simple to do manually but I don't want to have to change the headers every Sunday... is this even possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I chart "by week" | Charts and Charting in Excel | |||
| Need to convert date to "day of the week only" | Excel Worksheet Functions | |||
| How do I "Sum sales figure for a finacial month to currenct week"? | Excel Worksheet Functions | |||
| Simple? Formula for "for the week starting Monday May Xxth" | Excel Worksheet Functions | |||
| How do I set up a sheet with date headers one week apart. | New Users to Excel | |||
Threaded Mode
