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.