software

I start new spreadsheets on Jan 1st and July 1st, then click and drag
them out row quot;Aquot; to have 6 months of days to work with. Since I only
want business days, I always have to manually go back and delete all of
the Saturdays and Sundays off each sheet. Not the hardest work in the
world but since I'm lazy I'd like to know if there is a way that I can
let Excel 2000 delete them automatically. All I need is Monday thru
Friday anyway.--
lsmft
------------------------------------------------------------------------
lsmft's Profile: www.excelforum.com/member.php...oamp;userid=30678
View this thread: www.excelforum.com/showthread...hreadid=520746Hi

Use
= WORKDAY(A2,1)
in A3 and fill down

Andy.

quot;lsmftquot; gt; wrote in message
...
gt;
gt; I start new spreadsheets on Jan 1st and July 1st, then click and drag
gt; them out row quot;Aquot; to have 6 months of days to work with. Since I only
gt; want business days, I always have to manually go back and delete all of
gt; the Saturdays and Sundays off each sheet. Not the hardest work in the
gt; world but since I'm lazy I'd like to know if there is a way that I can
gt; let Excel 2000 delete them automatically. All I need is Monday thru
gt; Friday anyway.
gt;
gt;
gt; --
gt; lsmft
gt; ------------------------------------------------------------------------
gt; lsmft's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30678
gt; View this thread: www.excelforum.com/showthread...hreadid=520746
gt;

Thanks for the fast response Andy, but this is not working for me.
I mistated my question though. I should have stated that I click on
cell A-1 and drag across on Row 1 until I get to June 30. In this way
each day will have it's own column.
Sorry for my confusing question.
Let's say:
A-1 is Jan 1, 2006
B-1 is Jan 2, 2006
C-1 is Jan 3, 2006 etc.--
lsmft
------------------------------------------------------------------------
lsmft's Profile: www.excelforum.com/member.php...oamp;userid=30678
View this thread: www.excelforum.com/showthread...hreadid=520746
Thanks for the fast response Andy, but this is not working for me.
I mistated my question though. I should have stated that I click on
cell A-1 and drag across on Row 1 until I get to June 30. In this way
each day will have it's own column.
Sorry for my confusing question.
Let's say:
A-1 is Jan 1, 2006
B-1 is Jan 2, 2006
C-1 is Jan 3, 2006 etc.--
lsmft
------------------------------------------------------------------------
lsmft's Profile: www.excelforum.com/member.php...oamp;userid=30678
View this thread: www.excelforum.com/showthread...hreadid=520746You can do exactly the same, but the other way around!
In B1 put
=WORKDAY(A1,1)
and fill it across!

Andy.

quot;lsmftquot; gt; wrote in
message ...
gt;
gt; Thanks for the fast response Andy, but this is not working for me.
gt; I mistated my question though. I should have stated that I click on
gt; cell A-1 and drag across on Row 1 until I get to June 30. In this way
gt; each day will have it's own column.
gt; Sorry for my confusing question.
gt; Let's say:
gt; A-1 is Jan 1, 2006
gt; B-1 is Jan 2, 2006
gt; C-1 is Jan 3, 2006 etc.
gt;
gt;
gt; --
gt; lsmft
gt; ------------------------------------------------------------------------
gt; lsmft's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30678
gt; View this thread: www.excelforum.com/showthread...hreadid=520746
gt;

Andy,
In cell A1 I put 01/01/06
In cell B1 I put =WORDAY(A1,1)
All I'm getting is #NAME?
When I click and drag, I drag #NAME? horizontally across row 1.
Am I doing something wrong here?--
lsmft
------------------------------------------------------------------------
lsmft's Profile: www.excelforum.com/member.php...oamp;userid=30678
View this thread: www.excelforum.com/showthread...hreadid=520746On Thu, 9 Mar 2006 15:19:33 -0600, lsmft
gt; wrote:

gt;
gt;Andy,
gt;In cell A1 I put 01/01/06
gt;In cell B1 I put =WORDAY(A1,1)
gt;All I'm getting is #NAME?
gt;When I click and drag, I drag #NAME? horizontally across row 1.
gt;Am I doing something wrong here?

You need to install the Analysis ToolPak.

See HELP for the WORKDAY function and it will tell you what to do when you see
a #NAME error
--ron

Try WORKDAY instead of WORDAY!

Andy.

quot;lsmftquot; gt; wrote in
message ...
gt;
gt; Andy,
gt; In cell A1 I put 01/01/06
gt; In cell B1 I put =WORDAY(A1,1)
gt; All I'm getting is #NAME?
gt; When I click and drag, I drag #NAME? horizontally across row 1.
gt; Am I doing something wrong here?
gt;
gt;
gt; --
gt; lsmft
gt; ------------------------------------------------------------------------
gt; lsmft's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30678
gt; View this thread: www.excelforum.com/showthread...hreadid=520746
gt;

Andy,
Sorry for the misspelling.
However I did have it spelled correctly in the Excel cell.
I'm now going to see what I can find about analysis tool pack.--
lsmft
------------------------------------------------------------------------
lsmft's Profile: www.excelforum.com/member.php...oamp;userid=30678
View this thread: www.excelforum.com/showthread...hreadid=520746quot;Andyquot; wrote:
gt; Hi
gt;
gt; Use
gt; = WORKDAY(A2,1)
gt; in A3 and fill down

Won't that only tell you which are the saturdays/sundays?

I use.
A1 = 01/01/06
A2 = if(workday(A1,2)=5,A1 3,A1 1)

Which when dragged across will give you ony Monday - Friday's without the
need to delete anything.