software

I need to create a planner - previously have manually inputted all the Mon
Tue dates and click and dragged the rest but wondered if there was a better
way. Need M, T, W, T, F dates skip weekend, start again.

Have tried doing it by dragging over a 2 week period to see if the pattern
is recognised but it doesn't work.

Laurina


Laurina

I am using Excel 2003 and I have tried the following:

MondayTuesdayWednesdayThursdayFridayMondayTuesdayWednesdayThursdayFriday

in columns A to J.

When i select the lot then drag to the right it starts from Monday then
end the week on Friday, then starts again with Monday, etc...

Is this what you are after?--
Petitboeuf
------------------------------------------------------------------------
Petitboeuf's Profile: www.excelforum.com/member.php...oamp;userid=10602
View this thread: www.excelforum.com/showthread...hreadid=535963Not quite. Here's an example

M28-Sep
T29-Sep
W30-Sep
Th1-Oct
F2-Oct
M4-Oct
T5-Oct
W6-Oct
Th7-Oct
F8-Octquot;Petitboeufquot; wrote:

gt;
gt; Laurina
gt;
gt; I am using Excel 2003 and I have tried the following:
gt;
gt; MondayTuesdayWednesdayThursdayFridayMondayTuesdayWednesdayThursdayFriday
gt;
gt; in columns A to J.
gt;
gt; When i select the lot then drag to the right it starts from Monday then
gt; end the week on Friday, then starts again with Monday, etc...
gt;
gt; Is this what you are after?
gt;
gt;
gt; --
gt; Petitboeuf
gt; ------------------------------------------------------------------------
gt; Petitboeuf's Profile: www.excelforum.com/member.php...oamp;userid=10602
gt; View this thread: www.excelforum.com/showthread...hreadid=535963
gt;
gt;

Hi Laurina

Try using the Workday() function.

With your first date in A1, in A2 enter
=WORKDAY(A1,1)
Copy down and you will just get the workdays of each week.
If you want to exclude Public Holidays from the list, then pout those
dates in a range of cells and either name the range as Holidays or refer
directly to the range of cells holding the dates with the following
modified formula
=WORKDAY(A1,1,holidays) or = WORKDAY(A1,1,$E1:$E10) where E1:E10 holds
the range of holiday dates.

--
Regards

Roger Govierquot;Laurinaquot; gt; wrote in message
...
gt; Not quite. Here's an example
gt;
gt; M 28-Sep
gt; T 29-Sep
gt; W 30-Sep
gt; Th 1-Oct
gt; F 2-Oct
gt; M 4-Oct
gt; T 5-Oct
gt; W 6-Oct
gt; Th 7-Oct
gt; F 8-Oct
gt;
gt;
gt; quot;Petitboeufquot; wrote:
gt;
gt;gt;
gt;gt; Laurina
gt;gt;
gt;gt; I am using Excel 2003 and I have tried the following:
gt;gt;
gt;gt; Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday
gt;gt; Thursday Friday
gt;gt;
gt;gt; in columns A to J.
gt;gt;
gt;gt; When i select the lot then drag to the right it starts from Monday
gt;gt; then
gt;gt; end the week on Friday, then starts again with Monday, etc...
gt;gt;
gt;gt; Is this what you are after?
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Petitboeuf
gt;gt; ------------------------------------------------------------------------
gt;gt; Petitboeuf's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=10602
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=535963
gt;gt;
gt;gt;
Thanks for that but the file isn't recognising the workday bit - comes up
with #name and then #ref.

quot;Roger Govierquot; wrote:

gt; Hi Laurina
gt;
gt; Try using the Workday() function.
gt;
gt; With your first date in A1, in A2 enter
gt; =WORKDAY(A1,1)
gt; Copy down and you will just get the workdays of each week.
gt; If you want to exclude Public Holidays from the list, then pout those
gt; dates in a range of cells and either name the range as Holidays or refer
gt; directly to the range of cells holding the dates with the following
gt; modified formula
gt; =WORKDAY(A1,1,holidays) or = WORKDAY(A1,1,$E1:$E10) where E1:E10 holds
gt; the range of holiday dates.
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Laurinaquot; gt; wrote in message
gt; ...
gt; gt; Not quite. Here's an example
gt; gt;
gt; gt; M 28-Sep
gt; gt; T 29-Sep
gt; gt; W 30-Sep
gt; gt; Th 1-Oct
gt; gt; F 2-Oct
gt; gt; M 4-Oct
gt; gt; T 5-Oct
gt; gt; W 6-Oct
gt; gt; Th 7-Oct
gt; gt; F 8-Oct
gt; gt;
gt; gt;
gt; gt; quot;Petitboeufquot; wrote:
gt; gt;
gt; gt;gt;
gt; gt;gt; Laurina
gt; gt;gt;
gt; gt;gt; I am using Excel 2003 and I have tried the following:
gt; gt;gt;
gt; gt;gt; Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday
gt; gt;gt; Thursday Friday
gt; gt;gt;
gt; gt;gt; in columns A to J.
gt; gt;gt;
gt; gt;gt; When i select the lot then drag to the right it starts from Monday
gt; gt;gt; then
gt; gt;gt; end the week on Friday, then starts again with Monday, etc...
gt; gt;gt;
gt; gt;gt; Is this what you are after?
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Petitboeuf
gt; gt;gt; ------------------------------------------------------------------------
gt; gt;gt; Petitboeuf's Profile:
gt; gt;gt; www.excelforum.com/member.php...oamp;userid=10602
gt; gt;gt; View this thread:
gt; gt;gt; www.excelforum.com/showthread...hreadid=535963
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

Hi Laurina

I should have added that you need the Analysis Toolpak loaded.
Toolsgt;Addinsgt; and check Analysis Toolpak

--
Regards

Roger Govierquot;Laurinaquot; gt; wrote in message
...
gt; Thanks for that but the file isn't recognising the workday bit - comes
gt; up
gt; with #name and then #ref.
gt;
gt; quot;Roger Govierquot; wrote:
gt;
gt;gt; Hi Laurina
gt;gt;
gt;gt; Try using the Workday() function.
gt;gt;
gt;gt; With your first date in A1, in A2 enter
gt;gt; =WORKDAY(A1,1)
gt;gt; Copy down and you will just get the workdays of each week.
gt;gt; If you want to exclude Public Holidays from the list, then pout those
gt;gt; dates in a range of cells and either name the range as Holidays or
gt;gt; refer
gt;gt; directly to the range of cells holding the dates with the following
gt;gt; modified formula
gt;gt; =WORKDAY(A1,1,holidays) or = WORKDAY(A1,1,$E1:$E10) where E1:E10
gt;gt; holds
gt;gt; the range of holiday dates.
gt;gt;
gt;gt; --
gt;gt; Regards
gt;gt;
gt;gt; Roger Govier
gt;gt;
gt;gt;
gt;gt; quot;Laurinaquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Not quite. Here's an example
gt;gt; gt;
gt;gt; gt; M 28-Sep
gt;gt; gt; T 29-Sep
gt;gt; gt; W 30-Sep
gt;gt; gt; Th 1-Oct
gt;gt; gt; F 2-Oct
gt;gt; gt; M 4-Oct
gt;gt; gt; T 5-Oct
gt;gt; gt; W 6-Oct
gt;gt; gt; Th 7-Oct
gt;gt; gt; F 8-Oct
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;Petitboeufquot; wrote:
gt;gt; gt;
gt;gt; gt;gt;
gt;gt; gt;gt; Laurina
gt;gt; gt;gt;
gt;gt; gt;gt; I am using Excel 2003 and I have tried the following:
gt;gt; gt;gt;
gt;gt; gt;gt; Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday
gt;gt; gt;gt; Thursday Friday
gt;gt; gt;gt;
gt;gt; gt;gt; in columns A to J.
gt;gt; gt;gt;
gt;gt; gt;gt; When i select the lot then drag to the right it starts from Monday
gt;gt; gt;gt; then
gt;gt; gt;gt; end the week on Friday, then starts again with Monday, etc...
gt;gt; gt;gt;
gt;gt; gt;gt; Is this what you are after?
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; --
gt;gt; gt;gt; Petitboeuf
gt;gt; gt;gt; ------------------------------------------------------------------------
gt;gt; gt;gt; Petitboeuf's Profile:
gt;gt; gt;gt; www.excelforum.com/member.php...oamp;userid=10602
gt;gt; gt;gt; View this thread:
gt;gt; gt;gt; www.excelforum.com/showthread...hreadid=535963
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;
Laurina

The WORKDAY Function is from the Analysis Toolpak Add-in.

Load it through Toolsgt;Add-ins to eliminate the #NAME! error.Gord Dibben MS Excel MVP

On Tue, 25 Apr 2006 09:25:01 -0700, Laurina gt;
wrote:

gt;Thanks for that but the file isn't recognising the workday bit - comes up
gt;with #name and then #ref.
gt;
gt;quot;Roger Govierquot; wrote:
gt;
gt;gt; Hi Laurina
gt;gt;
gt;gt; Try using the Workday() function.
gt;gt;
gt;gt; With your first date in A1, in A2 enter
gt;gt; =WORKDAY(A1,1)
gt;gt; Copy down and you will just get the workdays of each week.
gt;gt; If you want to exclude Public Holidays from the list, then pout those
gt;gt; dates in a range of cells and either name the range as Holidays or refer
gt;gt; directly to the range of cells holding the dates with the following
gt;gt; modified formula
gt;gt; =WORKDAY(A1,1,holidays) or = WORKDAY(A1,1,$E1:$E10) where E1:E10 holds
gt;gt; the range of holiday dates.
gt;gt;
gt;gt; --
gt;gt; Regards
gt;gt;
gt;gt; Roger Govier
gt;gt;
gt;gt;
gt;gt; quot;Laurinaquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Not quite. Here's an example
gt;gt; gt;
gt;gt; gt; M 28-Sep
gt;gt; gt; T 29-Sep
gt;gt; gt; W 30-Sep
gt;gt; gt; Th 1-Oct
gt;gt; gt; F 2-Oct
gt;gt; gt; M 4-Oct
gt;gt; gt; T 5-Oct
gt;gt; gt; W 6-Oct
gt;gt; gt; Th 7-Oct
gt;gt; gt; F 8-Oct
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;Petitboeufquot; wrote:
gt;gt; gt;
gt;gt; gt;gt;
gt;gt; gt;gt; Laurina
gt;gt; gt;gt;
gt;gt; gt;gt; I am using Excel 2003 and I have tried the following:
gt;gt; gt;gt;
gt;gt; gt;gt; Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday
gt;gt; gt;gt; Thursday Friday
gt;gt; gt;gt;
gt;gt; gt;gt; in columns A to J.
gt;gt; gt;gt;
gt;gt; gt;gt; When i select the lot then drag to the right it starts from Monday
gt;gt; gt;gt; then
gt;gt; gt;gt; end the week on Friday, then starts again with Monday, etc...
gt;gt; gt;gt;
gt;gt; gt;gt; Is this what you are after?
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; --
gt;gt; gt;gt; Petitboeuf
gt;gt; gt;gt; ------------------------------------------------------------------------
gt;gt; gt;gt; Petitboeuf's Profile:
gt;gt; gt;gt; www.excelforum.com/member.php...oamp;userid=10602
gt;gt; gt;gt; View this thread:
gt;gt; gt;gt; www.excelforum.com/showthread...hreadid=535963
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;thanks. Have done this but #ref doesn't go away. possibly something to do
with the server??

quot;Roger Govierquot; wrote:

gt; Hi Laurina
gt;
gt; I should have added that you need the Analysis Toolpak loaded.
gt; Toolsgt;Addinsgt; and check Analysis Toolpak
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Laurinaquot; gt; wrote in message
gt; ...
gt; gt; Thanks for that but the file isn't recognising the workday bit - comes
gt; gt; up
gt; gt; with #name and then #ref.
gt; gt;
gt; gt; quot;Roger Govierquot; wrote:
gt; gt;
gt; gt;gt; Hi Laurina
gt; gt;gt;
gt; gt;gt; Try using the Workday() function.
gt; gt;gt;
gt; gt;gt; With your first date in A1, in A2 enter
gt; gt;gt; =WORKDAY(A1,1)
gt; gt;gt; Copy down and you will just get the workdays of each week.
gt; gt;gt; If you want to exclude Public Holidays from the list, then pout those
gt; gt;gt; dates in a range of cells and either name the range as Holidays or
gt; gt;gt; refer
gt; gt;gt; directly to the range of cells holding the dates with the following
gt; gt;gt; modified formula
gt; gt;gt; =WORKDAY(A1,1,holidays) or = WORKDAY(A1,1,$E1:$E10) where E1:E10
gt; gt;gt; holds
gt; gt;gt; the range of holiday dates.
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Regards
gt; gt;gt;
gt; gt;gt; Roger Govier
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Laurinaquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Not quite. Here's an example
gt; gt;gt; gt;
gt; gt;gt; gt; M 28-Sep
gt; gt;gt; gt; T 29-Sep
gt; gt;gt; gt; W 30-Sep
gt; gt;gt; gt; Th 1-Oct
gt; gt;gt; gt; F 2-Oct
gt; gt;gt; gt; M 4-Oct
gt; gt;gt; gt; T 5-Oct
gt; gt;gt; gt; W 6-Oct
gt; gt;gt; gt; Th 7-Oct
gt; gt;gt; gt; F 8-Oct
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Petitboeufquot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Laurina
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; I am using Excel 2003 and I have tried the following:
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday
gt; gt;gt; gt;gt; Thursday Friday
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; in columns A to J.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; When i select the lot then drag to the right it starts from Monday
gt; gt;gt; gt;gt; then
gt; gt;gt; gt;gt; end the week on Friday, then starts again with Monday, etc...
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Is this what you are after?
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; --
gt; gt;gt; gt;gt; Petitboeuf
gt; gt;gt; gt;gt; ------------------------------------------------------------------------
gt; gt;gt; gt;gt; Petitboeuf's Profile:
gt; gt;gt; gt;gt; www.excelforum.com/member.php...oamp;userid=10602
gt; gt;gt; gt;gt; View this thread:
gt; gt;gt; gt;gt; www.excelforum.com/showthread...hreadid=535963
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

ignore last message - had entered date as text - it now works - thanks

quot;Roger Govierquot; wrote:

gt; Hi Laurina
gt;
gt; I should have added that you need the Analysis Toolpak loaded.
gt; Toolsgt;Addinsgt; and check Analysis Toolpak
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Laurinaquot; gt; wrote in message
gt; ...
gt; gt; Thanks for that but the file isn't recognising the workday bit - comes
gt; gt; up
gt; gt; with #name and then #ref.
gt; gt;
gt; gt; quot;Roger Govierquot; wrote:
gt; gt;
gt; gt;gt; Hi Laurina
gt; gt;gt;
gt; gt;gt; Try using the Workday() function.
gt; gt;gt;
gt; gt;gt; With your first date in A1, in A2 enter
gt; gt;gt; =WORKDAY(A1,1)
gt; gt;gt; Copy down and you will just get the workdays of each week.
gt; gt;gt; If you want to exclude Public Holidays from the list, then pout those
gt; gt;gt; dates in a range of cells and either name the range as Holidays or
gt; gt;gt; refer
gt; gt;gt; directly to the range of cells holding the dates with the following
gt; gt;gt; modified formula
gt; gt;gt; =WORKDAY(A1,1,holidays) or = WORKDAY(A1,1,$E1:$E10) where E1:E10
gt; gt;gt; holds
gt; gt;gt; the range of holiday dates.
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Regards
gt; gt;gt;
gt; gt;gt; Roger Govier
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Laurinaquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Not quite. Here's an example
gt; gt;gt; gt;
gt; gt;gt; gt; M 28-Sep
gt; gt;gt; gt; T 29-Sep
gt; gt;gt; gt; W 30-Sep
gt; gt;gt; gt; Th 1-Oct
gt; gt;gt; gt; F 2-Oct
gt; gt;gt; gt; M 4-Oct
gt; gt;gt; gt; T 5-Oct
gt; gt;gt; gt; W 6-Oct
gt; gt;gt; gt; Th 7-Oct
gt; gt;gt; gt; F 8-Oct
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Petitboeufquot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Laurina
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; I am using Excel 2003 and I have tried the following:
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday
gt; gt;gt; gt;gt; Thursday Friday
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; in columns A to J.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; When i select the lot then drag to the right it starts from Monday
gt; gt;gt; gt;gt; then
gt; gt;gt; gt;gt; end the week on Friday, then starts again with Monday, etc...
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Is this what you are after?
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; --
gt; gt;gt; gt;gt; Petitboeuf
gt; gt;gt; gt;gt; ------------------------------------------------------------------------
gt; gt;gt; gt;gt; Petitboeuf's Profile:
gt; gt;gt; gt;gt; www.excelforum.com/member.php...oamp;userid=10602
gt; gt;gt; gt;gt; View this thread:
gt; gt;gt; gt;gt; www.excelforum.com/showthread...hreadid=535963
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;