| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
show only Tue wed thu on year long log
I have a mileage log that I use only on Tuesday, Wednesday and Thursday. How
do I set up a macro or use the fill series to fill out for the whole year? I'm using Excel 2007 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
show only Tue wed thu on year long log
Put these 3 dates into A2:A4
1-Jan-09 6-Jan-09 7-Jan-09 then just place in A5: =A2+7 Copy A5 down as far as required to generate the required series And if you need a day indicator for the dates in A2 down you could place in B2: =TEXT(A2,"ddd") and copy B2 down -- Max Singapore http://savefile.com/projects/236895 Downloads:21,000 Files:370 Subscribers:66 xdemechanik --- "Al" wrote: I have a mileage log that I use only on Tuesday, Wednesday and Thursday. How do I set up a macro or use the fill series to fill out for the whole year? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
show only Tue wed thu on year long log
This was so easy it was embarrassing! :)
Thank you! Al "Max" wrote: Put these 3 dates into A2:A4 1-Jan-09 6-Jan-09 7-Jan-09 then just place in A5: =A2+7 Copy A5 down as far as required to generate the required series And if you need a day indicator for the dates in A2 down you could place in B2: =TEXT(A2,"ddd") and copy B2 down -- Max Singapore http://savefile.com/projects/236895 Downloads:21,000 Files:370 Subscribers:66 xdemechanik --- "Al" wrote: I have a mileage log that I use only on Tuesday, Wednesday and Thursday. How do I set up a macro or use the fill series to fill out for the whole year? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
show only Tue wed thu on year long log
No prob. You're welcome.
-- Max Singapore http://savefile.com/projects/236895 Downloads:22,000 Files:370 Subscribers:65 xdemechanik --- "Al" wrote: This was so easy it was embarrassing! :) Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, how can I show very long text in a single cell? | Excel Discussion (Misc queries) | |||
| show date as day of the year | Excel Worksheet Functions | |||
| how to show long x-axis label in two lines? | Excel Discussion (Misc queries) | |||
| How do i break really long bars to show short ones in Excel? | Charts and Charting in Excel | |||
| Long numbers show up as Scientific Notation | Excel Discussion (Misc queries) | |||
Linear Mode
