How to make Friday as weekend instead of Sat/Sun in Workday Functi
Dear Naushad ,
I have tried following formula and it works as per your need.
=A1+B1+INT((B1+A1-6)/6)-INT((B1-6)/6)
H S Shastri
Pl press YES if found useful.
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++
"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.
|