View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.misc
daddylonglegs
 
Posts: n/a
Default Business Days Only


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