show only Tue wed thu on year long log

A

Al

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
 
M

Max

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
 
Top