How to make Friday as weekend instead of Sat/Sun in Workday Functi
=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.
|