SET SATURDAY AS WORKING DAY IN EXCEL
Rohin,
My original formula does exactly what you want, just change the days array
=start_date+SIGN(days)*SMALL(IF((WEEKDAY(start_dat e+SIGN(days)*
(ROW(INDIRECT("1:"&ABS(days)*10))))={2,3,4,5,6,7}) *
ISNA(MATCH(start_date+SIGN(days)*(ROW(INDIRECT("1: "&ABS(days)*10))),holidays
,0)),
ROW(INDIRECT("1:"&ABS(days)*10))),ABS(days))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Rohin Bhatia" wrote in message
...
Dear Bob
Sorry - Im somewhat new to this . Let me clarify my exact problem.
Lets say that a task requires say 20 working days. Starting day say June
1.
How do I arrive at end date by considering 6 working days in the week -
Thus
only Sunday is the off day . All other days including Saturday are
working.
Pls help .
Thanks
Rohin
"Rohin Bhatia" wrote:
HOW CAN I CALCULATE WORKDAYS IN EXCEL BY SETTING SATURDAY ALSO AS A
WORKING
DAY ??
|