No Sat & Sundays

  • Thread starter Thread starter lsmft
  • Start date Start date
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
 
All 3 Cotton-pick'n suggestions worked just great. Thanks much to you
all.
 
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
 
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

New Years Day formula? 3
dates of month automation 3
Easy question (just not for me) 2
new day in next worksheet Day 1 plus 1? 1
Date formula/help 4
Re-assigning weekend days in "Networkdays" Function 2
Create a shorter list of dates 11
Shift Schedule Formula 1

Back
Top