Date exclude weekdays
 

Hi,

Creating a cell range in which I enter a single date at the top of a column.
I then fill 15 cells underneath this single cell ( a column) with a formula:
=A6+1

which gives me the following day. It gives me the weekends though.... I
know I can exclude weekends by using the fill function and then choosing
weekdays. But I have to do this everytime... Is there a way to create a
formula which will only fill my range with the weekdays without having to
come and fix this everytime?

Thanks!

Luke

Take a look at WORKDAY() function in XL Help. The function is part of
the Analysis Toolpak Add-in.



In article ,
LukePW wrote:

Hi,

Creating a cell range in which I enter a single date at the top of a column.
I then fill 15 cells underneath this single cell ( a column) with a formula:
=A6+1

which gives me the following day. It gives me the weekends though.... I
know I can exclude weekends by using the fill function and then choosing
weekdays. But I have to do this everytime... Is there a way to create a
formula which will only fill my range with the weekdays without having to
come and fix this everytime?

Thanks!

Luke

"JE McGimpsey" wrote in message
...
Take a look at WORKDAY() function in XL Help. The function is part of
the Analysis Toolpak Add-in.



or if you don't want to install the Analysis Toolpak Addin:

=A6+1+(WEEKDAY(A6+1,3)4)*(7-WEEKDAY(A6+1,3))

copied down as far as you need


--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


In article ,
LukePW wrote:

Hi,

Creating a cell range in which I enter a single date at the top of a
column.
I then fill 15 cells underneath this single cell ( a column) with a
formula:
=A6+1

which gives me the following day. It gives me the weekends though.... I
know I can exclude weekends by using the fill function and then choosing
weekdays. But I have to do this everytime... Is there a way to create a
formula which will only fill my range with the weekdays without having
to
come and fix this everytime?

Thanks!

Luke

for this particular case, wouldn't it be just as easy to skip the weekend?

=A6+1+(WEEKDAY(A6,1)=6)*2

Of course JE's suggestion allows consideration of holidays.
--
Regards.
Tom Ogilvy

"Sandy Mann" wrote in message
...
"JE McGimpsey" wrote in message
...
Take a look at WORKDAY() function in XL Help. The function is part of
the Analysis Toolpak Add-in.



or if you don't want to install the Analysis Toolpak Addin:

=A6+1+(WEEKDAY(A6+1,3)4)*(7-WEEKDAY(A6+1,3))

copied down as far as you need


--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


In article ,
LukePW wrote:

Hi,

Creating a cell range in which I enter a single date at the top of a
column.
I then fill 15 cells underneath this single cell ( a column) with a
formula:
=A6+1

which gives me the following day. It gives me the weekends though....
I
know I can exclude weekends by using the fill function and then
choosing
weekdays. But I have to do this everytime... Is there a way to create
a
formula which will only fill my range with the weekdays without having
to
come and fix this everytime?

Thanks!

Luke

=A6+1+(WEEKDAY(A6+1,3)4)*(7-WEEKDAY(A6+1,3))

Of course if I were to think about it more clearly

=A6+1+(WEEKDAY(A6+1,3)=5)*2

is all that is required

Sandy

--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


"Sandy Mann" wrote in message
...
"JE McGimpsey" wrote in message
...
Take a look at WORKDAY() function in XL Help. The function is part of
the Analysis Toolpak Add-in.



or if you don't want to install the Analysis Toolpak Addin:

=A6+1+(WEEKDAY(A6+1,3)4)*(7-WEEKDAY(A6+1,3))

copied down as far as you need


--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


In article ,
LukePW wrote:

Hi,

Creating a cell range in which I enter a single date at the top of a
column.
I then fill 15 cells underneath this single cell ( a column) with a
formula:
=A6+1

which gives me the following day. It gives me the weekends though....
I
know I can exclude weekends by using the fill function and then
choosing
weekdays. But I have to do this everytime... Is there a way to create
a
formula which will only fill my range with the weekdays without having
to
come and fix this everytime?

Thanks!

Luke

"Tom Ogilvy" wrote in message
...
for this particular case, wouldn't it be just as easy to skip the weekend?

=A6+1+(WEEKDAY(A6,1)=6)*2

Of course JE's suggestion allows consideration of holidays.
--
Regards.
Tom Ogilvy

Great minds? <g

Regards

Sandy

--
to e-mail direct replace @mailintor.com with @tiscali.co.uk



"Sandy Mann" wrote in message
...
"JE McGimpsey" wrote in message
...
Take a look at WORKDAY() function in XL Help. The function is part of
the Analysis Toolpak Add-in.



or if you don't want to install the Analysis Toolpak Addin:

=A6+1+(WEEKDAY(A6+1,3)4)*(7-WEEKDAY(A6+1,3))

copied down as far as you need


--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


In article ,
LukePW wrote:

Hi,

Creating a cell range in which I enter a single date at the top of a
column.
I then fill 15 cells underneath this single cell ( a column) with a
formula:
=A6+1

which gives me the following day. It gives me the weekends
though....
I
know I can exclude weekends by using the fill function and then
choosing
weekdays. But I have to do this everytime... Is there a way to
create
a
formula which will only fill my range with the weekdays without
having
to
come and fix this everytime?

Thanks!

Luke

Thanks !

"JE McGimpsey" wrote:

Take a look at WORKDAY() function in XL Help. The function is part of
the Analysis Toolpak Add-in.



In article ,
LukePW wrote:

Hi,

Creating a cell range in which I enter a single date at the top of a column.
I then fill 15 cells underneath this single cell ( a column) with a formula:
=A6+1

which gives me the following day. It gives me the weekends though.... I
know I can exclude weekends by using the fill function and then choosing
weekdays. But I have to do this everytime... Is there a way to create a
formula which will only fill my range with the weekdays without having to
come and fix this everytime?

Thanks!

Luke

Thanks Sandy - will try that

"Sandy Mann" wrote:

"JE McGimpsey" wrote in message
...
Take a look at WORKDAY() function in XL Help. The function is part of
the Analysis Toolpak Add-in.



or if you don't want to install the Analysis Toolpak Addin:

=A6+1+(WEEKDAY(A6+1,3)4)*(7-WEEKDAY(A6+1,3))

copied down as far as you need


--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


In article ,
LukePW wrote:

Hi,

Creating a cell range in which I enter a single date at the top of a
column.
I then fill 15 cells underneath this single cell ( a column) with a
formula:
=A6+1

which gives me the following day. It gives me the weekends though.... I
know I can exclude weekends by using the fill function and then choosing
weekdays. But I have to do this everytime... Is there a way to create a
formula which will only fill my range with the weekdays without having
to
come and fix this everytime?

Thanks!

Luke

Hello Sandy,

I have tried your formula but was not able to make this work. I get an
error ($name). Of course, it might not help that my Excel is in French
(although we seem to use the same lingo). Any ideas?

Luke

"Sandy Mann" wrote:

=A6+1+(WEEKDAY(A6+1,3)4)*(7-WEEKDAY(A6+1,3))

Of course if I were to think about it more clearly

=A6+1+(WEEKDAY(A6+1,3)=5)*2

is all that is required

Sandy

--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


"Sandy Mann" wrote in message
...
"JE McGimpsey" wrote in message
...
Take a look at WORKDAY() function in XL Help. The function is part of
the Analysis Toolpak Add-in.



or if you don't want to install the Analysis Toolpak Addin:

=A6+1+(WEEKDAY(A6+1,3)4)*(7-WEEKDAY(A6+1,3))

copied down as far as you need


--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


In article ,
LukePW wrote:

Hi,

Creating a cell range in which I enter a single date at the top of a
column.
I then fill 15 cells underneath this single cell ( a column) with a
formula:
=A6+1

which gives me the following day. It gives me the weekends though....
I
know I can exclude weekends by using the fill function and then
choosing
weekdays. But I have to do this everytime... Is there a way to create
a
formula which will only fill my range with the weekdays without having
to
come and fix this everytime?

Thanks!

Luke

Sorry Luke. Your Excel is obviously telling you that it does not recognise
the WEEKDAY function but I have no idea what the French function is called.
Perhaps one of the multi-linguists will jump in and advise you. In my Excel
when it doesn't recognise a function name is gives the error message #NAME?
so there are subtle differences but I would expect the syntax to be similar.
Try looking through the functions in the fx dialog box to see it you can
find the WEEKDAY equivalent.

Hope you get the help you need

Regards

Sandy

--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


"LukePW" wrote in message
...
Hello Sandy,

I have tried your formula but was not able to make this work. I get an
error ($name). Of course, it might not help that my Excel is in French
(although we seem to use the same lingo). Any ideas?

Luke

"Sandy Mann" wrote:

=A6+1+(WEEKDAY(A6+1,3)4)*(7-WEEKDAY(A6+1,3))

Of course if I were to think about it more clearly

=A6+1+(WEEKDAY(A6+1,3)=5)*2

is all that is required

Sandy

--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


"Sandy Mann" wrote in message
...
"JE McGimpsey" wrote in message
...
Take a look at WORKDAY() function in XL Help. The function is part
of
the Analysis Toolpak Add-in.



or if you don't want to install the Analysis Toolpak Addin:

=A6+1+(WEEKDAY(A6+1,3)4)*(7-WEEKDAY(A6+1,3))

copied down as far as you need


--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


In article ,
LukePW wrote:

Hi,

Creating a cell range in which I enter a single date at the top of
a
column.
I then fill 15 cells underneath this single cell ( a column) with
a
formula:
=A6+1

which gives me the following day. It gives me the weekends
though....
I
know I can exclude weekends by using the fill function and then
choosing
weekdays. But I have to do this everytime... Is there a way to
create
a
formula which will only fill my range with the weekdays without
having
to
come and fix this everytime?

Thanks!

Luke