? ???? Excel? WORKDAY , WORKDAY.INTL , NETWORKDAYS ? NETWORKDAYS.INTL ??? ???? ??? ?? ?? ? ??? ???? ??? ????? ???? ??? ?????.

Microsoft Excel? Workday ????? ?? ??? ?????. WORKDAY ???? ???? ????? ?? NETWORKDAYS ? ?? ??? ???? ?????. WORKDAY.INTL ? NETWORKDAYS.INTL (Excel 2010 ???? ??)? ?? ??? ?? ?? ? ??? ?????.

? ??? ?????.

Excel Workday ?? :

WORKDAY ??? ?? (??? ? ???)? ???? ?? ?? ??? ??? ?? ?? ??? ?????. ??? ??? ????.

WORKDAY(start_date, days, [holidays])

• start_date : ?? ??.
• days : ?? (??) ?? ?? (??)? ?.
• holidays : (?? ??) ??? ??? ???? ??? ? ??.

? : B2 : B5 : =WORKDAY(DATE(2015,5,6), 30, B2:B5) ? ???? ??? 2015 ? 5 ? 6 ??? 30 ?? ???? ????.

Excel Workday.intl ?? :

WORKDAY.INTL ??? ?? ?? ??? ???? WORKDAY ?????. ??? ??? ????.

WORKDAY.INTL(start_date, days, [weekend], [holidays])

• weekend : ??? ?????. ??? ?? ?? ??? ???? ?? (1-7, 11-17) ?? 7 ? ??? (???? ??? ??? ?? "0000011") ? ? ????.
• ?? ??? WORKDAY ? ?????.

? : ???? ???? A5 : A5? ?? ? ???? A2?? 30 ?? ???? ????? : =WORKDAY.INTL(A2, 30, 7, A5:A8) ?? =WORKDAY.INTL(A2, 30, "0000110", A5:A8)

Excel NetworkDays ?? :

NETWORKDAYS ??? ??? ? ?? ??? ???? ?????. ??? ??? ????.

NETWORKDAYS(start_date, end_date, [holidays])

• start_date ? end_date : ??? ?? ? ?? ??.
• holidays : (?? ??) ?? ??? ???? ??? ?.

? : A2 : A5 : =NETWORKDAYS(B2, C2, $A$2:$A$5) ? ?? ??, B2? C2 ??? ???? ?????

Excel NetworkDays.intl ?? :

NETWORKDAYS.INTL NETWORKDAYS ? ????? WORKDAY.INTL ? ??? weekend ??? ???? ??? ?? ?? ??? ?????.

? : B2? C2 ??? ???, ???? A2? ??? ?? ? ??? A2 : A5? ???? ????? : =NETWORKDAYS.INTL(B2, C2, 11, $A$2:$A$5) ?? =NETWORKDAYS.INTL(B2, C2, "0000001", $A$2:$A$5)

??? ?? :

??? ??? ???? ?? ? ? ????. WORKDAY , WEEKDAY ? COUNTIF ??? ??? ??? ??? ???? ??? ?? ?? ??? ???? ????? ???? ?? ? ? ????.

? ??? ? ???? ???? ???? ?? ?? ? ??? ?? Excel? ??? Workday ??? ??? ? ????. ??? ?????? ?? ?? ?? ??? ???? ???????.

? ??? Excel Workday ? Networkdays ??? ???? ?????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!