PaulW Wrote:
"Andy" wrote:
Hi
Use
= WORKDAY(A2,1)
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.
As Ron says, that won't work as it stands. If you don't have access to
Analysis ToolPak you could use
= if(weekday(A1)=6,A1+3,A1+1)
but that only works if A1 is a weekday (which 01/01/2006 isn't) - and
it doesn't exclude holidays, although with a more complex formula you
could incorporate both
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=520746