"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.