| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display "this week" column headers w/date & day of week?
Put this formula in A1:
=TODAY()-WEEKDAY(TODAY())+1 and apply a custom format to the cell of "mm/dd/yyy - dddd" (without the quotes). Then in B1 enter the formula: =A1+1 Or, put this formula... =TODAY()-WEEKDAY(TODAY())+ROWS($1:1) in A1 and just copy it down. Rick |
| 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
