The OP needs a *general* function for a *six* day workweek... your formula
won't work in the general case.

Rick


"Teethless mama" wrote in message
...
=WORKDAY(A1+1,A2-1)


"P.B.Mohan" wrote:

Dear Teethless mama,

Thanks alot for your reply.

Suppose I have 29-Mar-08 in A1 (This is the start date of a job); I have
10
in A2 (This is the number of working days that the job takes); I would
like
A3 to have the date on which the job would be complete.

29-Mar-08 is a Saturday. 10 working days means Monday to Saturday of the
next week (Sunday being a holiday) and Monday to Thursday of the week
after
next ending on 10-Apr-08. How do I get this using a formula?

Thanks in advance, P.BMohan

"Teethless mama" wrote:

A1: start date
A2: end date

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))1))


"P.B.Mohan" wrote:

The existing WORKDAY function in MS_Excel assumes a five-day working
week
from Monday through Friday. How can I use the function in a six-day
working
week situation from Monday through Saturday?