If you want to fill a series of dates and exclude Thursdays:
Enter the starting date in your first cell, assume A1:
A1 = 7/1/2008
Enter this formula in A2 and copy down as needed:
=A1+CHOOSE(WEEKDAY(A1),1,1,1,2,1,1,1)
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.
