show only Tue wed thu on year long log

  • Thread starter Thread starter Al
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Series fill only copying and fill series greyed out 1
In excel how set up a sequence to drag Mon, Tues, Wed Etc, 1
Cumulative Timesheet Entries 5
CALENDAR CREATION 1
Sum of data where a condition applies 1
Fill handle increments year instead of day 1
Grouping large amount of data by day-of-week 3
how many times a particular day of the week appears in a given month 4

Back
Top