When I set up a spreadsheet for 6 months, I have my dates across the
top. eg (A-1)=Jan.1, (B-1)=Jan 2 etc.
Is it possible to do this but not have any weekends? After setting the
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 the
sheet to June 30 without having any Saturdays and Sundays and still
keep the dates in order? By that I mean if Friday is Jan 5th, then the
next column would represent Monday Jan 7th.


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=532307