No Sat & Sundays

L

lsmft

When I set up a spreadsheet for 6 months, I have my dates across th
top. eg (A-1)=Jan.1, (B-1)=Jan 2 etc.
Is it possible to do this but not have any weekends? After setting th
sheet up, I always go back to delete all of the Saturdays & Sundays.
Is there a way to put in say, A-1=Jan 1st, click and drag across th
sheet to June 30 without having any Saturdays and Sundays and stil
keep the dates in order? By that I mean if Friday is Jan 5th, then th
next column would represent Monday Jan 7th
 
P

Paul B

Your welcome
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Top