Instead of
=WORKDAY(A1,B1)
try
=WORKDAY(A1+1,B1)-1

where A1 contains the Start Date and B1 the Number of Days...

Not sure how this will work if you add Holidays and the holiday falls on Fri
or Sun...
Can you pl. test and let us know?


"Naushad" wrote:

How can i change weekend from saturday & Sunday to Friday for a workday
function