No Sat & Sundays

[lsmft]

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.

[Pete_UK]

Enter your first date in A1 - ensure this is not a Saturday or Sunday.
In B1 enter this formula:

=IF(WEEKDAY(A1,2)=5,A1+3,A1+1)

Format this as a date, then copy across your columns.

Hope this helps.

Pete

[Paul B]

lsmft, right click when you drag the formula, when you let go you will have
some options to pick from, pick fill weekdays
--
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

"lsmft" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Kevin B]

Enter in the starting date and then in the next column to the right insert
the following formula and copy to all remaining cells. The formula assumes
that the first date is in Cell A1:

=IF(WEEKDAY(A1+1)=7,A1+3,IF(WEEKDAY(A1+1) =1,A1+2,A1+1))
--
Kevin Backmann


"lsmft" wrote:

>
> 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
>
>

[lsmft]

All 3 Cotton-pick'n suggestions worked just great. Thanks much to you all.

[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

"lsmft" <[email protected]> wrote in
message news:[email protected]...
>
> All 3 Cotton-pick'n suggestions worked just great. Thanks much to you
> all.
>
>
> --
> lsmft
> ------------------------------------------------------------------------
> lsmft's Profile:
> http://www.excelforum.com/member.php...o&userid=30678
> View this thread: http://www.excelforum.com/showthread...hreadid=532307
>