Business Days Only
On Fri, 10 Mar 2006 03:16:27 -0800, 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.
You might want to consider the difference between the functions WORKDAY and
WEEKDAY.
As written, the conditional portion of your equation in A2 (and as copied
down), will ALWAYS evaluate to FALSE.
--ron
|