I don't think your formula skips over Sundays correctly. Try this...

A1: 3/29/2008
A2: 19 <<and 20

Rick


"N Harkawat" wrote in message
...

A1: start date
A2: number of days

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


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