Laurina

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

Load it through ToolsAdd-ins to eliminate the #NAME! error.


Gord Dibben MS Excel MVP

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

Thanks for that but the file isn't recognising the workday bit - comes up
with #name and then #ref.

"Roger Govier" wrote:

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 Govier


"Laurina" wrote in message
...
Not quite. Here's an example

M 28-Sep
T 29-Sep
W 30-Sep
Th 1-Oct
F 2-Oct
M 4-Oct
T 5-Oct
W 6-Oct
Th 7-Oct
F 8-Oct


"Petitboeuf" wrote:


Laurina

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

Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday
Thursday Friday

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:
http://www.excelforum.com/member.php...o&userid=10602
View this thread:
http://www.excelforum.com/showthread...hreadid=535963