WOrkday function - change working days
=WORKDAY(start_date,days)-SUMPRODUCT(--(WEEKDAY(ROW(INDEX($1:$65536,start_da
te,1):INDEX($1:$65536,WORKDAY(start_date,days),1)) )=1))
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Ashutosh" wrote in message
...
How do I define working days as Monday to Saturday for the Workday
function ?
( instead of standard Monday to Friday
|