"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