hi,
for the first Friday it works but not for second and other fridays

"Teethless mama" wrote:

=A1+B1+SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1+B1&":"&B1)))=6))

Normally ENTER


"Naushad" wrote:

if in cell A1 is the no.of days and in cell B1 is the start date. How can I
have workday calculated in cell c1 with Friday as weekend and saturdays &
sundays as workdays.