Рабочая книга содержит чистый лист «Шаблон» и заполненный лист «Пример». Данные примера условны и не описывают реальных контрагентов.
Как работать
- Календарные дни включают обе граничные даты. Зависимости проверяются вручную.
- Полоса показывает план на 28 дней с даты контроля; она не пересчитывает последовательность.
- Готовность от 0% до 100%. Недопустимый период обозначается явно.
- Скопируйте файл для своего объекта. Заполняйте желтые ячейки, сохраняя формулы в белых.
- Числа вводите числами. Даты введите как даты Excel. Доли вводите процентами.
- Пустая обязательная величина означает отсутствие данных; ноль означает установленное нулевое значение.
- Проверяйте исходные документы и полномочия. Итог в таблице не заменяет решения ответственного лица.
- В файле задано 40-я строка как конец расчетной области. При расширении добавьте строки, формулы, проверки и итоги.
Проверка на примере
На листе «Пример» E12 дает 8. Формулы пересчитываются при изменении входов. Денежные значения заданы в рублях, если в заголовке не указано иное.
Редакция 29.10.2026.
Содержимое рабочей книги
Ниже приведены исходные ячейки и формулы. Для пересчёта и заполнения скачайте файл XLSX. Пример содержит условные данные.
Лист «Шаблон»
| Строка | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | OBYOM / Рабочий шаблон | ||||||||||||||||||||||||||||||||||||
| 2 | График работ | ||||||||||||||||||||||||||||||||||||
| 3 | Желтые ячейки — ввод. Белые — расчет. Инструкция в одноименном файле MD. | ||||||||||||||||||||||||||||||||||||
| 5 | Дата | 29.10.2026 | |||||||||||||||||||||||||||||||||||
| 6 | Просрочено этапов | =IF(COUNTA(B11:B40)=0,"",COUNTIF(I11:I40,"Просрочен")) | |||||||||||||||||||||||||||||||||||
| 10 | ID | Этап | Начало | Окончание | Дней | Готовность | Ответственный | Зависимость | Статус | =$B$5+0 | =$B$5+1 | =$B$5+2 | =$B$5+3 | =$B$5+4 | =$B$5+5 | =$B$5+6 | =$B$5+7 | =$B$5+8 | =$B$5+9 | =$B$5+10 | =$B$5+11 | =$B$5+12 | =$B$5+13 | =$B$5+14 | =$B$5+15 | =$B$5+16 | =$B$5+17 | =$B$5+18 | =$B$5+19 | =$B$5+20 | =$B$5+21 | =$B$5+22 | =$B$5+23 | =$B$5+24 | =$B$5+25 | =$B$5+26 | =$B$5+27 |
| 11 | 1 | =IF(B11="","",IF(OR(NOT(ISNUMBER(C11)),NOT(ISNUMBER(D11))),"Нет дат",IF(D11<C11,"Ошибка дат",D11-C11+1))) | =IF(B11="","",IF(OR(NOT(ISNUMBER(C11)),NOT(ISNUMBER(D11)),NOT(ISNUMBER(F11))),"Нет данных",IF(D11<C11,"Ошибка дат",IF(F11=1,"Завершен",IF(D11<$B$5,"Просрочен","В работе"))))) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(J$10>=$C11,J$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(K$10>=$C11,K$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(L$10>=$C11,L$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(M$10>=$C11,M$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(N$10>=$C11,N$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(O$10>=$C11,O$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(P$10>=$C11,P$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(Q$10>=$C11,Q$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(R$10>=$C11,R$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(S$10>=$C11,S$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(T$10>=$C11,T$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(U$10>=$C11,U$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(V$10>=$C11,V$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(W$10>=$C11,W$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(X$10>=$C11,X$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(Y$10>=$C11,Y$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(Z$10>=$C11,Z$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AA$10>=$C11,AA$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AB$10>=$C11,AB$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AC$10>=$C11,AC$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AD$10>=$C11,AD$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AE$10>=$C11,AE$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AF$10>=$C11,AF$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AG$10>=$C11,AG$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AH$10>=$C11,AH$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AI$10>=$C11,AI$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AJ$10>=$C11,AJ$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AK$10>=$C11,AK$10<=$D11),1,"")) | ||||||
| 12 | 2 | =IF(B12="","",IF(OR(NOT(ISNUMBER(C12)),NOT(ISNUMBER(D12))),"Нет дат",IF(D12<C12,"Ошибка дат",D12-C12+1))) | =IF(B12="","",IF(OR(NOT(ISNUMBER(C12)),NOT(ISNUMBER(D12)),NOT(ISNUMBER(F12))),"Нет данных",IF(D12<C12,"Ошибка дат",IF(F12=1,"Завершен",IF(D12<$B$5,"Просрочен","В работе"))))) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(J$10>=$C12,J$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(K$10>=$C12,K$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(L$10>=$C12,L$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(M$10>=$C12,M$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(N$10>=$C12,N$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(O$10>=$C12,O$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(P$10>=$C12,P$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(Q$10>=$C12,Q$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(R$10>=$C12,R$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(S$10>=$C12,S$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(T$10>=$C12,T$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(U$10>=$C12,U$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(V$10>=$C12,V$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(W$10>=$C12,W$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(X$10>=$C12,X$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(Y$10>=$C12,Y$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(Z$10>=$C12,Z$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AA$10>=$C12,AA$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AB$10>=$C12,AB$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AC$10>=$C12,AC$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AD$10>=$C12,AD$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AE$10>=$C12,AE$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AF$10>=$C12,AF$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AG$10>=$C12,AG$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AH$10>=$C12,AH$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AI$10>=$C12,AI$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AJ$10>=$C12,AJ$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AK$10>=$C12,AK$10<=$D12),1,"")) | ||||||
| 13 | 3 | =IF(B13="","",IF(OR(NOT(ISNUMBER(C13)),NOT(ISNUMBER(D13))),"Нет дат",IF(D13<C13,"Ошибка дат",D13-C13+1))) | =IF(B13="","",IF(OR(NOT(ISNUMBER(C13)),NOT(ISNUMBER(D13)),NOT(ISNUMBER(F13))),"Нет данных",IF(D13<C13,"Ошибка дат",IF(F13=1,"Завершен",IF(D13<$B$5,"Просрочен","В работе"))))) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(J$10>=$C13,J$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(K$10>=$C13,K$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(L$10>=$C13,L$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(M$10>=$C13,M$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(N$10>=$C13,N$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(O$10>=$C13,O$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(P$10>=$C13,P$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(Q$10>=$C13,Q$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(R$10>=$C13,R$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(S$10>=$C13,S$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(T$10>=$C13,T$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(U$10>=$C13,U$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(V$10>=$C13,V$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(W$10>=$C13,W$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(X$10>=$C13,X$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(Y$10>=$C13,Y$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(Z$10>=$C13,Z$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AA$10>=$C13,AA$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AB$10>=$C13,AB$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AC$10>=$C13,AC$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AD$10>=$C13,AD$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AE$10>=$C13,AE$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AF$10>=$C13,AF$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AG$10>=$C13,AG$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AH$10>=$C13,AH$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AI$10>=$C13,AI$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AJ$10>=$C13,AJ$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AK$10>=$C13,AK$10<=$D13),1,"")) | ||||||
| 14 | 4 | =IF(B14="","",IF(OR(NOT(ISNUMBER(C14)),NOT(ISNUMBER(D14))),"Нет дат",IF(D14<C14,"Ошибка дат",D14-C14+1))) | =IF(B14="","",IF(OR(NOT(ISNUMBER(C14)),NOT(ISNUMBER(D14)),NOT(ISNUMBER(F14))),"Нет данных",IF(D14<C14,"Ошибка дат",IF(F14=1,"Завершен",IF(D14<$B$5,"Просрочен","В работе"))))) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(J$10>=$C14,J$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(K$10>=$C14,K$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(L$10>=$C14,L$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(M$10>=$C14,M$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(N$10>=$C14,N$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(O$10>=$C14,O$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(P$10>=$C14,P$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(Q$10>=$C14,Q$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(R$10>=$C14,R$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(S$10>=$C14,S$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(T$10>=$C14,T$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(U$10>=$C14,U$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(V$10>=$C14,V$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(W$10>=$C14,W$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(X$10>=$C14,X$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(Y$10>=$C14,Y$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(Z$10>=$C14,Z$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AA$10>=$C14,AA$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AB$10>=$C14,AB$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AC$10>=$C14,AC$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AD$10>=$C14,AD$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AE$10>=$C14,AE$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AF$10>=$C14,AF$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AG$10>=$C14,AG$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AH$10>=$C14,AH$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AI$10>=$C14,AI$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AJ$10>=$C14,AJ$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AK$10>=$C14,AK$10<=$D14),1,"")) | ||||||
| 15 | 5 | =IF(B15="","",IF(OR(NOT(ISNUMBER(C15)),NOT(ISNUMBER(D15))),"Нет дат",IF(D15<C15,"Ошибка дат",D15-C15+1))) | =IF(B15="","",IF(OR(NOT(ISNUMBER(C15)),NOT(ISNUMBER(D15)),NOT(ISNUMBER(F15))),"Нет данных",IF(D15<C15,"Ошибка дат",IF(F15=1,"Завершен",IF(D15<$B$5,"Просрочен","В работе"))))) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(J$10>=$C15,J$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(K$10>=$C15,K$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(L$10>=$C15,L$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(M$10>=$C15,M$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(N$10>=$C15,N$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(O$10>=$C15,O$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(P$10>=$C15,P$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(Q$10>=$C15,Q$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(R$10>=$C15,R$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(S$10>=$C15,S$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(T$10>=$C15,T$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(U$10>=$C15,U$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(V$10>=$C15,V$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(W$10>=$C15,W$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(X$10>=$C15,X$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(Y$10>=$C15,Y$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(Z$10>=$C15,Z$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AA$10>=$C15,AA$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AB$10>=$C15,AB$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AC$10>=$C15,AC$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AD$10>=$C15,AD$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AE$10>=$C15,AE$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AF$10>=$C15,AF$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AG$10>=$C15,AG$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AH$10>=$C15,AH$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AI$10>=$C15,AI$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AJ$10>=$C15,AJ$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AK$10>=$C15,AK$10<=$D15),1,"")) | ||||||
| 16 | 6 | =IF(B16="","",IF(OR(NOT(ISNUMBER(C16)),NOT(ISNUMBER(D16))),"Нет дат",IF(D16<C16,"Ошибка дат",D16-C16+1))) | =IF(B16="","",IF(OR(NOT(ISNUMBER(C16)),NOT(ISNUMBER(D16)),NOT(ISNUMBER(F16))),"Нет данных",IF(D16<C16,"Ошибка дат",IF(F16=1,"Завершен",IF(D16<$B$5,"Просрочен","В работе"))))) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(J$10>=$C16,J$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(K$10>=$C16,K$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(L$10>=$C16,L$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(M$10>=$C16,M$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(N$10>=$C16,N$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(O$10>=$C16,O$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(P$10>=$C16,P$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(Q$10>=$C16,Q$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(R$10>=$C16,R$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(S$10>=$C16,S$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(T$10>=$C16,T$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(U$10>=$C16,U$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(V$10>=$C16,V$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(W$10>=$C16,W$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(X$10>=$C16,X$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(Y$10>=$C16,Y$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(Z$10>=$C16,Z$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AA$10>=$C16,AA$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AB$10>=$C16,AB$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AC$10>=$C16,AC$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AD$10>=$C16,AD$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AE$10>=$C16,AE$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AF$10>=$C16,AF$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AG$10>=$C16,AG$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AH$10>=$C16,AH$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AI$10>=$C16,AI$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AJ$10>=$C16,AJ$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AK$10>=$C16,AK$10<=$D16),1,"")) | ||||||
| 17 | 7 | =IF(B17="","",IF(OR(NOT(ISNUMBER(C17)),NOT(ISNUMBER(D17))),"Нет дат",IF(D17<C17,"Ошибка дат",D17-C17+1))) | =IF(B17="","",IF(OR(NOT(ISNUMBER(C17)),NOT(ISNUMBER(D17)),NOT(ISNUMBER(F17))),"Нет данных",IF(D17<C17,"Ошибка дат",IF(F17=1,"Завершен",IF(D17<$B$5,"Просрочен","В работе"))))) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(J$10>=$C17,J$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(K$10>=$C17,K$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(L$10>=$C17,L$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(M$10>=$C17,M$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(N$10>=$C17,N$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(O$10>=$C17,O$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(P$10>=$C17,P$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(Q$10>=$C17,Q$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(R$10>=$C17,R$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(S$10>=$C17,S$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(T$10>=$C17,T$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(U$10>=$C17,U$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(V$10>=$C17,V$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(W$10>=$C17,W$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(X$10>=$C17,X$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(Y$10>=$C17,Y$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(Z$10>=$C17,Z$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AA$10>=$C17,AA$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AB$10>=$C17,AB$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AC$10>=$C17,AC$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AD$10>=$C17,AD$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AE$10>=$C17,AE$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AF$10>=$C17,AF$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AG$10>=$C17,AG$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AH$10>=$C17,AH$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AI$10>=$C17,AI$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AJ$10>=$C17,AJ$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AK$10>=$C17,AK$10<=$D17),1,"")) | ||||||
| 18 | 8 | =IF(B18="","",IF(OR(NOT(ISNUMBER(C18)),NOT(ISNUMBER(D18))),"Нет дат",IF(D18<C18,"Ошибка дат",D18-C18+1))) | =IF(B18="","",IF(OR(NOT(ISNUMBER(C18)),NOT(ISNUMBER(D18)),NOT(ISNUMBER(F18))),"Нет данных",IF(D18<C18,"Ошибка дат",IF(F18=1,"Завершен",IF(D18<$B$5,"Просрочен","В работе"))))) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(J$10>=$C18,J$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(K$10>=$C18,K$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(L$10>=$C18,L$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(M$10>=$C18,M$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(N$10>=$C18,N$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(O$10>=$C18,O$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(P$10>=$C18,P$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(Q$10>=$C18,Q$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(R$10>=$C18,R$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(S$10>=$C18,S$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(T$10>=$C18,T$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(U$10>=$C18,U$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(V$10>=$C18,V$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(W$10>=$C18,W$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(X$10>=$C18,X$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(Y$10>=$C18,Y$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(Z$10>=$C18,Z$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AA$10>=$C18,AA$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AB$10>=$C18,AB$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AC$10>=$C18,AC$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AD$10>=$C18,AD$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AE$10>=$C18,AE$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AF$10>=$C18,AF$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AG$10>=$C18,AG$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AH$10>=$C18,AH$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AI$10>=$C18,AI$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AJ$10>=$C18,AJ$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AK$10>=$C18,AK$10<=$D18),1,"")) | ||||||
| 19 | 9 | =IF(B19="","",IF(OR(NOT(ISNUMBER(C19)),NOT(ISNUMBER(D19))),"Нет дат",IF(D19<C19,"Ошибка дат",D19-C19+1))) | =IF(B19="","",IF(OR(NOT(ISNUMBER(C19)),NOT(ISNUMBER(D19)),NOT(ISNUMBER(F19))),"Нет данных",IF(D19<C19,"Ошибка дат",IF(F19=1,"Завершен",IF(D19<$B$5,"Просрочен","В работе"))))) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(J$10>=$C19,J$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(K$10>=$C19,K$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(L$10>=$C19,L$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(M$10>=$C19,M$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(N$10>=$C19,N$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(O$10>=$C19,O$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(P$10>=$C19,P$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(Q$10>=$C19,Q$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(R$10>=$C19,R$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(S$10>=$C19,S$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(T$10>=$C19,T$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(U$10>=$C19,U$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(V$10>=$C19,V$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(W$10>=$C19,W$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(X$10>=$C19,X$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(Y$10>=$C19,Y$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(Z$10>=$C19,Z$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AA$10>=$C19,AA$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AB$10>=$C19,AB$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AC$10>=$C19,AC$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AD$10>=$C19,AD$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AE$10>=$C19,AE$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AF$10>=$C19,AF$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AG$10>=$C19,AG$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AH$10>=$C19,AH$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AI$10>=$C19,AI$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AJ$10>=$C19,AJ$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AK$10>=$C19,AK$10<=$D19),1,"")) | ||||||
| 20 | 10 | =IF(B20="","",IF(OR(NOT(ISNUMBER(C20)),NOT(ISNUMBER(D20))),"Нет дат",IF(D20<C20,"Ошибка дат",D20-C20+1))) | =IF(B20="","",IF(OR(NOT(ISNUMBER(C20)),NOT(ISNUMBER(D20)),NOT(ISNUMBER(F20))),"Нет данных",IF(D20<C20,"Ошибка дат",IF(F20=1,"Завершен",IF(D20<$B$5,"Просрочен","В работе"))))) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(J$10>=$C20,J$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(K$10>=$C20,K$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(L$10>=$C20,L$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(M$10>=$C20,M$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(N$10>=$C20,N$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(O$10>=$C20,O$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(P$10>=$C20,P$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(Q$10>=$C20,Q$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(R$10>=$C20,R$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(S$10>=$C20,S$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(T$10>=$C20,T$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(U$10>=$C20,U$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(V$10>=$C20,V$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(W$10>=$C20,W$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(X$10>=$C20,X$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(Y$10>=$C20,Y$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(Z$10>=$C20,Z$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AA$10>=$C20,AA$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AB$10>=$C20,AB$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AC$10>=$C20,AC$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AD$10>=$C20,AD$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AE$10>=$C20,AE$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AF$10>=$C20,AF$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AG$10>=$C20,AG$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AH$10>=$C20,AH$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AI$10>=$C20,AI$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AJ$10>=$C20,AJ$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AK$10>=$C20,AK$10<=$D20),1,"")) | ||||||
| 21 | 11 | =IF(B21="","",IF(OR(NOT(ISNUMBER(C21)),NOT(ISNUMBER(D21))),"Нет дат",IF(D21<C21,"Ошибка дат",D21-C21+1))) | =IF(B21="","",IF(OR(NOT(ISNUMBER(C21)),NOT(ISNUMBER(D21)),NOT(ISNUMBER(F21))),"Нет данных",IF(D21<C21,"Ошибка дат",IF(F21=1,"Завершен",IF(D21<$B$5,"Просрочен","В работе"))))) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(J$10>=$C21,J$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(K$10>=$C21,K$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(L$10>=$C21,L$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(M$10>=$C21,M$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(N$10>=$C21,N$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(O$10>=$C21,O$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(P$10>=$C21,P$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(Q$10>=$C21,Q$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(R$10>=$C21,R$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(S$10>=$C21,S$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(T$10>=$C21,T$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(U$10>=$C21,U$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(V$10>=$C21,V$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(W$10>=$C21,W$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(X$10>=$C21,X$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(Y$10>=$C21,Y$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(Z$10>=$C21,Z$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AA$10>=$C21,AA$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AB$10>=$C21,AB$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AC$10>=$C21,AC$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AD$10>=$C21,AD$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AE$10>=$C21,AE$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AF$10>=$C21,AF$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AG$10>=$C21,AG$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AH$10>=$C21,AH$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AI$10>=$C21,AI$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AJ$10>=$C21,AJ$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AK$10>=$C21,AK$10<=$D21),1,"")) | ||||||
| 22 | 12 | =IF(B22="","",IF(OR(NOT(ISNUMBER(C22)),NOT(ISNUMBER(D22))),"Нет дат",IF(D22<C22,"Ошибка дат",D22-C22+1))) | =IF(B22="","",IF(OR(NOT(ISNUMBER(C22)),NOT(ISNUMBER(D22)),NOT(ISNUMBER(F22))),"Нет данных",IF(D22<C22,"Ошибка дат",IF(F22=1,"Завершен",IF(D22<$B$5,"Просрочен","В работе"))))) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(J$10>=$C22,J$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(K$10>=$C22,K$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(L$10>=$C22,L$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(M$10>=$C22,M$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(N$10>=$C22,N$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(O$10>=$C22,O$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(P$10>=$C22,P$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(Q$10>=$C22,Q$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(R$10>=$C22,R$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(S$10>=$C22,S$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(T$10>=$C22,T$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(U$10>=$C22,U$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(V$10>=$C22,V$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(W$10>=$C22,W$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(X$10>=$C22,X$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(Y$10>=$C22,Y$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(Z$10>=$C22,Z$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AA$10>=$C22,AA$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AB$10>=$C22,AB$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AC$10>=$C22,AC$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AD$10>=$C22,AD$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AE$10>=$C22,AE$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AF$10>=$C22,AF$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AG$10>=$C22,AG$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AH$10>=$C22,AH$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AI$10>=$C22,AI$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AJ$10>=$C22,AJ$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AK$10>=$C22,AK$10<=$D22),1,"")) | ||||||
| 23 | 13 | =IF(B23="","",IF(OR(NOT(ISNUMBER(C23)),NOT(ISNUMBER(D23))),"Нет дат",IF(D23<C23,"Ошибка дат",D23-C23+1))) | =IF(B23="","",IF(OR(NOT(ISNUMBER(C23)),NOT(ISNUMBER(D23)),NOT(ISNUMBER(F23))),"Нет данных",IF(D23<C23,"Ошибка дат",IF(F23=1,"Завершен",IF(D23<$B$5,"Просрочен","В работе"))))) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(J$10>=$C23,J$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(K$10>=$C23,K$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(L$10>=$C23,L$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(M$10>=$C23,M$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(N$10>=$C23,N$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(O$10>=$C23,O$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(P$10>=$C23,P$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(Q$10>=$C23,Q$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(R$10>=$C23,R$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(S$10>=$C23,S$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(T$10>=$C23,T$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(U$10>=$C23,U$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(V$10>=$C23,V$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(W$10>=$C23,W$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(X$10>=$C23,X$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(Y$10>=$C23,Y$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(Z$10>=$C23,Z$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AA$10>=$C23,AA$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AB$10>=$C23,AB$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AC$10>=$C23,AC$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AD$10>=$C23,AD$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AE$10>=$C23,AE$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AF$10>=$C23,AF$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AG$10>=$C23,AG$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AH$10>=$C23,AH$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AI$10>=$C23,AI$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AJ$10>=$C23,AJ$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AK$10>=$C23,AK$10<=$D23),1,"")) | ||||||
| 24 | 14 | =IF(B24="","",IF(OR(NOT(ISNUMBER(C24)),NOT(ISNUMBER(D24))),"Нет дат",IF(D24<C24,"Ошибка дат",D24-C24+1))) | =IF(B24="","",IF(OR(NOT(ISNUMBER(C24)),NOT(ISNUMBER(D24)),NOT(ISNUMBER(F24))),"Нет данных",IF(D24<C24,"Ошибка дат",IF(F24=1,"Завершен",IF(D24<$B$5,"Просрочен","В работе"))))) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(J$10>=$C24,J$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(K$10>=$C24,K$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(L$10>=$C24,L$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(M$10>=$C24,M$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(N$10>=$C24,N$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(O$10>=$C24,O$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(P$10>=$C24,P$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(Q$10>=$C24,Q$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(R$10>=$C24,R$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(S$10>=$C24,S$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(T$10>=$C24,T$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(U$10>=$C24,U$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(V$10>=$C24,V$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(W$10>=$C24,W$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(X$10>=$C24,X$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(Y$10>=$C24,Y$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(Z$10>=$C24,Z$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AA$10>=$C24,AA$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AB$10>=$C24,AB$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AC$10>=$C24,AC$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AD$10>=$C24,AD$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AE$10>=$C24,AE$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AF$10>=$C24,AF$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AG$10>=$C24,AG$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AH$10>=$C24,AH$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AI$10>=$C24,AI$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AJ$10>=$C24,AJ$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AK$10>=$C24,AK$10<=$D24),1,"")) | ||||||
| 25 | 15 | =IF(B25="","",IF(OR(NOT(ISNUMBER(C25)),NOT(ISNUMBER(D25))),"Нет дат",IF(D25<C25,"Ошибка дат",D25-C25+1))) | =IF(B25="","",IF(OR(NOT(ISNUMBER(C25)),NOT(ISNUMBER(D25)),NOT(ISNUMBER(F25))),"Нет данных",IF(D25<C25,"Ошибка дат",IF(F25=1,"Завершен",IF(D25<$B$5,"Просрочен","В работе"))))) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(J$10>=$C25,J$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(K$10>=$C25,K$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(L$10>=$C25,L$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(M$10>=$C25,M$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(N$10>=$C25,N$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(O$10>=$C25,O$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(P$10>=$C25,P$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(Q$10>=$C25,Q$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(R$10>=$C25,R$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(S$10>=$C25,S$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(T$10>=$C25,T$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(U$10>=$C25,U$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(V$10>=$C25,V$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(W$10>=$C25,W$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(X$10>=$C25,X$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(Y$10>=$C25,Y$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(Z$10>=$C25,Z$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AA$10>=$C25,AA$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AB$10>=$C25,AB$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AC$10>=$C25,AC$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AD$10>=$C25,AD$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AE$10>=$C25,AE$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AF$10>=$C25,AF$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AG$10>=$C25,AG$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AH$10>=$C25,AH$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AI$10>=$C25,AI$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AJ$10>=$C25,AJ$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AK$10>=$C25,AK$10<=$D25),1,"")) | ||||||
| 26 | 16 | =IF(B26="","",IF(OR(NOT(ISNUMBER(C26)),NOT(ISNUMBER(D26))),"Нет дат",IF(D26<C26,"Ошибка дат",D26-C26+1))) | =IF(B26="","",IF(OR(NOT(ISNUMBER(C26)),NOT(ISNUMBER(D26)),NOT(ISNUMBER(F26))),"Нет данных",IF(D26<C26,"Ошибка дат",IF(F26=1,"Завершен",IF(D26<$B$5,"Просрочен","В работе"))))) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(J$10>=$C26,J$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(K$10>=$C26,K$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(L$10>=$C26,L$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(M$10>=$C26,M$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(N$10>=$C26,N$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(O$10>=$C26,O$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(P$10>=$C26,P$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(Q$10>=$C26,Q$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(R$10>=$C26,R$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(S$10>=$C26,S$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(T$10>=$C26,T$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(U$10>=$C26,U$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(V$10>=$C26,V$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(W$10>=$C26,W$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(X$10>=$C26,X$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(Y$10>=$C26,Y$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(Z$10>=$C26,Z$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AA$10>=$C26,AA$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AB$10>=$C26,AB$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AC$10>=$C26,AC$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AD$10>=$C26,AD$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AE$10>=$C26,AE$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AF$10>=$C26,AF$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AG$10>=$C26,AG$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AH$10>=$C26,AH$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AI$10>=$C26,AI$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AJ$10>=$C26,AJ$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AK$10>=$C26,AK$10<=$D26),1,"")) | ||||||
| 27 | 17 | =IF(B27="","",IF(OR(NOT(ISNUMBER(C27)),NOT(ISNUMBER(D27))),"Нет дат",IF(D27<C27,"Ошибка дат",D27-C27+1))) | =IF(B27="","",IF(OR(NOT(ISNUMBER(C27)),NOT(ISNUMBER(D27)),NOT(ISNUMBER(F27))),"Нет данных",IF(D27<C27,"Ошибка дат",IF(F27=1,"Завершен",IF(D27<$B$5,"Просрочен","В работе"))))) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(J$10>=$C27,J$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(K$10>=$C27,K$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(L$10>=$C27,L$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(M$10>=$C27,M$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(N$10>=$C27,N$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(O$10>=$C27,O$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(P$10>=$C27,P$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(Q$10>=$C27,Q$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(R$10>=$C27,R$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(S$10>=$C27,S$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(T$10>=$C27,T$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(U$10>=$C27,U$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(V$10>=$C27,V$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(W$10>=$C27,W$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(X$10>=$C27,X$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(Y$10>=$C27,Y$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(Z$10>=$C27,Z$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AA$10>=$C27,AA$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AB$10>=$C27,AB$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AC$10>=$C27,AC$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AD$10>=$C27,AD$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AE$10>=$C27,AE$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AF$10>=$C27,AF$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AG$10>=$C27,AG$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AH$10>=$C27,AH$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AI$10>=$C27,AI$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AJ$10>=$C27,AJ$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AK$10>=$C27,AK$10<=$D27),1,"")) | ||||||
| 28 | 18 | =IF(B28="","",IF(OR(NOT(ISNUMBER(C28)),NOT(ISNUMBER(D28))),"Нет дат",IF(D28<C28,"Ошибка дат",D28-C28+1))) | =IF(B28="","",IF(OR(NOT(ISNUMBER(C28)),NOT(ISNUMBER(D28)),NOT(ISNUMBER(F28))),"Нет данных",IF(D28<C28,"Ошибка дат",IF(F28=1,"Завершен",IF(D28<$B$5,"Просрочен","В работе"))))) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(J$10>=$C28,J$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(K$10>=$C28,K$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(L$10>=$C28,L$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(M$10>=$C28,M$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(N$10>=$C28,N$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(O$10>=$C28,O$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(P$10>=$C28,P$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(Q$10>=$C28,Q$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(R$10>=$C28,R$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(S$10>=$C28,S$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(T$10>=$C28,T$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(U$10>=$C28,U$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(V$10>=$C28,V$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(W$10>=$C28,W$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(X$10>=$C28,X$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(Y$10>=$C28,Y$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(Z$10>=$C28,Z$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AA$10>=$C28,AA$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AB$10>=$C28,AB$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AC$10>=$C28,AC$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AD$10>=$C28,AD$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AE$10>=$C28,AE$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AF$10>=$C28,AF$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AG$10>=$C28,AG$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AH$10>=$C28,AH$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AI$10>=$C28,AI$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AJ$10>=$C28,AJ$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AK$10>=$C28,AK$10<=$D28),1,"")) | ||||||
| 29 | 19 | =IF(B29="","",IF(OR(NOT(ISNUMBER(C29)),NOT(ISNUMBER(D29))),"Нет дат",IF(D29<C29,"Ошибка дат",D29-C29+1))) | =IF(B29="","",IF(OR(NOT(ISNUMBER(C29)),NOT(ISNUMBER(D29)),NOT(ISNUMBER(F29))),"Нет данных",IF(D29<C29,"Ошибка дат",IF(F29=1,"Завершен",IF(D29<$B$5,"Просрочен","В работе"))))) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(J$10>=$C29,J$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(K$10>=$C29,K$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(L$10>=$C29,L$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(M$10>=$C29,M$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(N$10>=$C29,N$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(O$10>=$C29,O$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(P$10>=$C29,P$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(Q$10>=$C29,Q$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(R$10>=$C29,R$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(S$10>=$C29,S$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(T$10>=$C29,T$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(U$10>=$C29,U$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(V$10>=$C29,V$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(W$10>=$C29,W$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(X$10>=$C29,X$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(Y$10>=$C29,Y$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(Z$10>=$C29,Z$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AA$10>=$C29,AA$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AB$10>=$C29,AB$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AC$10>=$C29,AC$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AD$10>=$C29,AD$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AE$10>=$C29,AE$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AF$10>=$C29,AF$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AG$10>=$C29,AG$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AH$10>=$C29,AH$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AI$10>=$C29,AI$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AJ$10>=$C29,AJ$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AK$10>=$C29,AK$10<=$D29),1,"")) | ||||||
| 30 | 20 | =IF(B30="","",IF(OR(NOT(ISNUMBER(C30)),NOT(ISNUMBER(D30))),"Нет дат",IF(D30<C30,"Ошибка дат",D30-C30+1))) | =IF(B30="","",IF(OR(NOT(ISNUMBER(C30)),NOT(ISNUMBER(D30)),NOT(ISNUMBER(F30))),"Нет данных",IF(D30<C30,"Ошибка дат",IF(F30=1,"Завершен",IF(D30<$B$5,"Просрочен","В работе"))))) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(J$10>=$C30,J$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(K$10>=$C30,K$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(L$10>=$C30,L$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(M$10>=$C30,M$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(N$10>=$C30,N$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(O$10>=$C30,O$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(P$10>=$C30,P$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(Q$10>=$C30,Q$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(R$10>=$C30,R$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(S$10>=$C30,S$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(T$10>=$C30,T$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(U$10>=$C30,U$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(V$10>=$C30,V$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(W$10>=$C30,W$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(X$10>=$C30,X$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(Y$10>=$C30,Y$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(Z$10>=$C30,Z$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AA$10>=$C30,AA$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AB$10>=$C30,AB$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AC$10>=$C30,AC$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AD$10>=$C30,AD$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AE$10>=$C30,AE$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AF$10>=$C30,AF$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AG$10>=$C30,AG$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AH$10>=$C30,AH$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AI$10>=$C30,AI$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AJ$10>=$C30,AJ$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AK$10>=$C30,AK$10<=$D30),1,"")) | ||||||
| 31 | 21 | =IF(B31="","",IF(OR(NOT(ISNUMBER(C31)),NOT(ISNUMBER(D31))),"Нет дат",IF(D31<C31,"Ошибка дат",D31-C31+1))) | =IF(B31="","",IF(OR(NOT(ISNUMBER(C31)),NOT(ISNUMBER(D31)),NOT(ISNUMBER(F31))),"Нет данных",IF(D31<C31,"Ошибка дат",IF(F31=1,"Завершен",IF(D31<$B$5,"Просрочен","В работе"))))) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(J$10>=$C31,J$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(K$10>=$C31,K$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(L$10>=$C31,L$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(M$10>=$C31,M$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(N$10>=$C31,N$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(O$10>=$C31,O$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(P$10>=$C31,P$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(Q$10>=$C31,Q$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(R$10>=$C31,R$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(S$10>=$C31,S$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(T$10>=$C31,T$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(U$10>=$C31,U$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(V$10>=$C31,V$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(W$10>=$C31,W$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(X$10>=$C31,X$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(Y$10>=$C31,Y$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(Z$10>=$C31,Z$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AA$10>=$C31,AA$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AB$10>=$C31,AB$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AC$10>=$C31,AC$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AD$10>=$C31,AD$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AE$10>=$C31,AE$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AF$10>=$C31,AF$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AG$10>=$C31,AG$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AH$10>=$C31,AH$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AI$10>=$C31,AI$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AJ$10>=$C31,AJ$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AK$10>=$C31,AK$10<=$D31),1,"")) | ||||||
| 32 | 22 | =IF(B32="","",IF(OR(NOT(ISNUMBER(C32)),NOT(ISNUMBER(D32))),"Нет дат",IF(D32<C32,"Ошибка дат",D32-C32+1))) | =IF(B32="","",IF(OR(NOT(ISNUMBER(C32)),NOT(ISNUMBER(D32)),NOT(ISNUMBER(F32))),"Нет данных",IF(D32<C32,"Ошибка дат",IF(F32=1,"Завершен",IF(D32<$B$5,"Просрочен","В работе"))))) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(J$10>=$C32,J$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(K$10>=$C32,K$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(L$10>=$C32,L$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(M$10>=$C32,M$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(N$10>=$C32,N$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(O$10>=$C32,O$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(P$10>=$C32,P$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(Q$10>=$C32,Q$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(R$10>=$C32,R$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(S$10>=$C32,S$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(T$10>=$C32,T$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(U$10>=$C32,U$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(V$10>=$C32,V$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(W$10>=$C32,W$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(X$10>=$C32,X$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(Y$10>=$C32,Y$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(Z$10>=$C32,Z$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AA$10>=$C32,AA$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AB$10>=$C32,AB$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AC$10>=$C32,AC$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AD$10>=$C32,AD$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AE$10>=$C32,AE$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AF$10>=$C32,AF$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AG$10>=$C32,AG$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AH$10>=$C32,AH$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AI$10>=$C32,AI$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AJ$10>=$C32,AJ$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AK$10>=$C32,AK$10<=$D32),1,"")) | ||||||
| 33 | 23 | =IF(B33="","",IF(OR(NOT(ISNUMBER(C33)),NOT(ISNUMBER(D33))),"Нет дат",IF(D33<C33,"Ошибка дат",D33-C33+1))) | =IF(B33="","",IF(OR(NOT(ISNUMBER(C33)),NOT(ISNUMBER(D33)),NOT(ISNUMBER(F33))),"Нет данных",IF(D33<C33,"Ошибка дат",IF(F33=1,"Завершен",IF(D33<$B$5,"Просрочен","В работе"))))) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(J$10>=$C33,J$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(K$10>=$C33,K$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(L$10>=$C33,L$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(M$10>=$C33,M$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(N$10>=$C33,N$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(O$10>=$C33,O$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(P$10>=$C33,P$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(Q$10>=$C33,Q$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(R$10>=$C33,R$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(S$10>=$C33,S$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(T$10>=$C33,T$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(U$10>=$C33,U$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(V$10>=$C33,V$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(W$10>=$C33,W$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(X$10>=$C33,X$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(Y$10>=$C33,Y$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(Z$10>=$C33,Z$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AA$10>=$C33,AA$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AB$10>=$C33,AB$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AC$10>=$C33,AC$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AD$10>=$C33,AD$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AE$10>=$C33,AE$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AF$10>=$C33,AF$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AG$10>=$C33,AG$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AH$10>=$C33,AH$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AI$10>=$C33,AI$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AJ$10>=$C33,AJ$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AK$10>=$C33,AK$10<=$D33),1,"")) | ||||||
| 34 | 24 | =IF(B34="","",IF(OR(NOT(ISNUMBER(C34)),NOT(ISNUMBER(D34))),"Нет дат",IF(D34<C34,"Ошибка дат",D34-C34+1))) | =IF(B34="","",IF(OR(NOT(ISNUMBER(C34)),NOT(ISNUMBER(D34)),NOT(ISNUMBER(F34))),"Нет данных",IF(D34<C34,"Ошибка дат",IF(F34=1,"Завершен",IF(D34<$B$5,"Просрочен","В работе"))))) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(J$10>=$C34,J$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(K$10>=$C34,K$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(L$10>=$C34,L$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(M$10>=$C34,M$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(N$10>=$C34,N$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(O$10>=$C34,O$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(P$10>=$C34,P$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(Q$10>=$C34,Q$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(R$10>=$C34,R$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(S$10>=$C34,S$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(T$10>=$C34,T$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(U$10>=$C34,U$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(V$10>=$C34,V$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(W$10>=$C34,W$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(X$10>=$C34,X$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(Y$10>=$C34,Y$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(Z$10>=$C34,Z$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AA$10>=$C34,AA$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AB$10>=$C34,AB$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AC$10>=$C34,AC$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AD$10>=$C34,AD$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AE$10>=$C34,AE$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AF$10>=$C34,AF$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AG$10>=$C34,AG$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AH$10>=$C34,AH$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AI$10>=$C34,AI$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AJ$10>=$C34,AJ$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AK$10>=$C34,AK$10<=$D34),1,"")) | ||||||
| 35 | 25 | =IF(B35="","",IF(OR(NOT(ISNUMBER(C35)),NOT(ISNUMBER(D35))),"Нет дат",IF(D35<C35,"Ошибка дат",D35-C35+1))) | =IF(B35="","",IF(OR(NOT(ISNUMBER(C35)),NOT(ISNUMBER(D35)),NOT(ISNUMBER(F35))),"Нет данных",IF(D35<C35,"Ошибка дат",IF(F35=1,"Завершен",IF(D35<$B$5,"Просрочен","В работе"))))) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(J$10>=$C35,J$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(K$10>=$C35,K$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(L$10>=$C35,L$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(M$10>=$C35,M$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(N$10>=$C35,N$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(O$10>=$C35,O$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(P$10>=$C35,P$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(Q$10>=$C35,Q$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(R$10>=$C35,R$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(S$10>=$C35,S$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(T$10>=$C35,T$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(U$10>=$C35,U$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(V$10>=$C35,V$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(W$10>=$C35,W$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(X$10>=$C35,X$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(Y$10>=$C35,Y$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(Z$10>=$C35,Z$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AA$10>=$C35,AA$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AB$10>=$C35,AB$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AC$10>=$C35,AC$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AD$10>=$C35,AD$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AE$10>=$C35,AE$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AF$10>=$C35,AF$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AG$10>=$C35,AG$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AH$10>=$C35,AH$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AI$10>=$C35,AI$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AJ$10>=$C35,AJ$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AK$10>=$C35,AK$10<=$D35),1,"")) | ||||||
| 36 | 26 | =IF(B36="","",IF(OR(NOT(ISNUMBER(C36)),NOT(ISNUMBER(D36))),"Нет дат",IF(D36<C36,"Ошибка дат",D36-C36+1))) | =IF(B36="","",IF(OR(NOT(ISNUMBER(C36)),NOT(ISNUMBER(D36)),NOT(ISNUMBER(F36))),"Нет данных",IF(D36<C36,"Ошибка дат",IF(F36=1,"Завершен",IF(D36<$B$5,"Просрочен","В работе"))))) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(J$10>=$C36,J$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(K$10>=$C36,K$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(L$10>=$C36,L$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(M$10>=$C36,M$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(N$10>=$C36,N$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(O$10>=$C36,O$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(P$10>=$C36,P$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(Q$10>=$C36,Q$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(R$10>=$C36,R$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(S$10>=$C36,S$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(T$10>=$C36,T$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(U$10>=$C36,U$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(V$10>=$C36,V$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(W$10>=$C36,W$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(X$10>=$C36,X$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(Y$10>=$C36,Y$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(Z$10>=$C36,Z$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AA$10>=$C36,AA$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AB$10>=$C36,AB$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AC$10>=$C36,AC$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AD$10>=$C36,AD$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AE$10>=$C36,AE$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AF$10>=$C36,AF$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AG$10>=$C36,AG$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AH$10>=$C36,AH$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AI$10>=$C36,AI$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AJ$10>=$C36,AJ$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AK$10>=$C36,AK$10<=$D36),1,"")) | ||||||
| 37 | 27 | =IF(B37="","",IF(OR(NOT(ISNUMBER(C37)),NOT(ISNUMBER(D37))),"Нет дат",IF(D37<C37,"Ошибка дат",D37-C37+1))) | =IF(B37="","",IF(OR(NOT(ISNUMBER(C37)),NOT(ISNUMBER(D37)),NOT(ISNUMBER(F37))),"Нет данных",IF(D37<C37,"Ошибка дат",IF(F37=1,"Завершен",IF(D37<$B$5,"Просрочен","В работе"))))) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(J$10>=$C37,J$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(K$10>=$C37,K$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(L$10>=$C37,L$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(M$10>=$C37,M$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(N$10>=$C37,N$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(O$10>=$C37,O$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(P$10>=$C37,P$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(Q$10>=$C37,Q$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(R$10>=$C37,R$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(S$10>=$C37,S$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(T$10>=$C37,T$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(U$10>=$C37,U$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(V$10>=$C37,V$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(W$10>=$C37,W$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(X$10>=$C37,X$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(Y$10>=$C37,Y$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(Z$10>=$C37,Z$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AA$10>=$C37,AA$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AB$10>=$C37,AB$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AC$10>=$C37,AC$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AD$10>=$C37,AD$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AE$10>=$C37,AE$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AF$10>=$C37,AF$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AG$10>=$C37,AG$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AH$10>=$C37,AH$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AI$10>=$C37,AI$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AJ$10>=$C37,AJ$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AK$10>=$C37,AK$10<=$D37),1,"")) | ||||||
| 38 | 28 | =IF(B38="","",IF(OR(NOT(ISNUMBER(C38)),NOT(ISNUMBER(D38))),"Нет дат",IF(D38<C38,"Ошибка дат",D38-C38+1))) | =IF(B38="","",IF(OR(NOT(ISNUMBER(C38)),NOT(ISNUMBER(D38)),NOT(ISNUMBER(F38))),"Нет данных",IF(D38<C38,"Ошибка дат",IF(F38=1,"Завершен",IF(D38<$B$5,"Просрочен","В работе"))))) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(J$10>=$C38,J$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(K$10>=$C38,K$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(L$10>=$C38,L$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(M$10>=$C38,M$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(N$10>=$C38,N$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(O$10>=$C38,O$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(P$10>=$C38,P$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(Q$10>=$C38,Q$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(R$10>=$C38,R$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(S$10>=$C38,S$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(T$10>=$C38,T$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(U$10>=$C38,U$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(V$10>=$C38,V$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(W$10>=$C38,W$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(X$10>=$C38,X$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(Y$10>=$C38,Y$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(Z$10>=$C38,Z$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AA$10>=$C38,AA$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AB$10>=$C38,AB$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AC$10>=$C38,AC$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AD$10>=$C38,AD$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AE$10>=$C38,AE$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AF$10>=$C38,AF$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AG$10>=$C38,AG$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AH$10>=$C38,AH$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AI$10>=$C38,AI$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AJ$10>=$C38,AJ$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AK$10>=$C38,AK$10<=$D38),1,"")) | ||||||
| 39 | 29 | =IF(B39="","",IF(OR(NOT(ISNUMBER(C39)),NOT(ISNUMBER(D39))),"Нет дат",IF(D39<C39,"Ошибка дат",D39-C39+1))) | =IF(B39="","",IF(OR(NOT(ISNUMBER(C39)),NOT(ISNUMBER(D39)),NOT(ISNUMBER(F39))),"Нет данных",IF(D39<C39,"Ошибка дат",IF(F39=1,"Завершен",IF(D39<$B$5,"Просрочен","В работе"))))) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(J$10>=$C39,J$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(K$10>=$C39,K$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(L$10>=$C39,L$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(M$10>=$C39,M$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(N$10>=$C39,N$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(O$10>=$C39,O$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(P$10>=$C39,P$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(Q$10>=$C39,Q$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(R$10>=$C39,R$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(S$10>=$C39,S$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(T$10>=$C39,T$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(U$10>=$C39,U$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(V$10>=$C39,V$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(W$10>=$C39,W$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(X$10>=$C39,X$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(Y$10>=$C39,Y$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(Z$10>=$C39,Z$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AA$10>=$C39,AA$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AB$10>=$C39,AB$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AC$10>=$C39,AC$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AD$10>=$C39,AD$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AE$10>=$C39,AE$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AF$10>=$C39,AF$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AG$10>=$C39,AG$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AH$10>=$C39,AH$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AI$10>=$C39,AI$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AJ$10>=$C39,AJ$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AK$10>=$C39,AK$10<=$D39),1,"")) | ||||||
| 40 | 30 | =IF(B40="","",IF(OR(NOT(ISNUMBER(C40)),NOT(ISNUMBER(D40))),"Нет дат",IF(D40<C40,"Ошибка дат",D40-C40+1))) | =IF(B40="","",IF(OR(NOT(ISNUMBER(C40)),NOT(ISNUMBER(D40)),NOT(ISNUMBER(F40))),"Нет данных",IF(D40<C40,"Ошибка дат",IF(F40=1,"Завершен",IF(D40<$B$5,"Просрочен","В работе"))))) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(J$10>=$C40,J$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(K$10>=$C40,K$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(L$10>=$C40,L$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(M$10>=$C40,M$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(N$10>=$C40,N$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(O$10>=$C40,O$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(P$10>=$C40,P$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(Q$10>=$C40,Q$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(R$10>=$C40,R$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(S$10>=$C40,S$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(T$10>=$C40,T$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(U$10>=$C40,U$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(V$10>=$C40,V$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(W$10>=$C40,W$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(X$10>=$C40,X$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(Y$10>=$C40,Y$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(Z$10>=$C40,Z$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AA$10>=$C40,AA$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AB$10>=$C40,AB$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AC$10>=$C40,AC$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AD$10>=$C40,AD$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AE$10>=$C40,AE$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AF$10>=$C40,AF$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AG$10>=$C40,AG$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AH$10>=$C40,AH$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AI$10>=$C40,AI$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AJ$10>=$C40,AJ$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AK$10>=$C40,AK$10<=$D40),1,"")) |
Лист «Пример»
| Строка | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | OBYOM / Учебный пример | ||||||||||||||||||||||||||||||||||||
| 2 | График работ | ||||||||||||||||||||||||||||||||||||
| 3 | Желтые ячейки — ввод. Белые — расчет. Инструкция в одноименном файле MD. | ||||||||||||||||||||||||||||||||||||
| 5 | Дата | 29.10.2026 | |||||||||||||||||||||||||||||||||||
| 6 | Просрочено этапов | =IF(COUNTA(B11:B40)=0,"",COUNTIF(I11:I40,"Просрочен")) | |||||||||||||||||||||||||||||||||||
| 10 | ID | Этап | Начало | Окончание | Дней | Готовность | Ответственный | Зависимость | Статус | =$B$5+0 | =$B$5+1 | =$B$5+2 | =$B$5+3 | =$B$5+4 | =$B$5+5 | =$B$5+6 | =$B$5+7 | =$B$5+8 | =$B$5+9 | =$B$5+10 | =$B$5+11 | =$B$5+12 | =$B$5+13 | =$B$5+14 | =$B$5+15 | =$B$5+16 | =$B$5+17 | =$B$5+18 | =$B$5+19 | =$B$5+20 | =$B$5+21 | =$B$5+22 | =$B$5+23 | =$B$5+24 | =$B$5+25 | =$B$5+26 | =$B$5+27 |
| 11 | 1 | Передача фронта | 26.10.2026 | 26.10.2026 | =IF(B11="","",IF(OR(NOT(ISNUMBER(C11)),NOT(ISNUMBER(D11))),"Нет дат",IF(D11<C11,"Ошибка дат",D11-C11+1))) | 100% | Заказчик | =IF(B11="","",IF(OR(NOT(ISNUMBER(C11)),NOT(ISNUMBER(D11)),NOT(ISNUMBER(F11))),"Нет данных",IF(D11<C11,"Ошибка дат",IF(F11=1,"Завершен",IF(D11<$B$5,"Просрочен","В работе"))))) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(J$10>=$C11,J$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(K$10>=$C11,K$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(L$10>=$C11,L$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(M$10>=$C11,M$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(N$10>=$C11,N$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(O$10>=$C11,O$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(P$10>=$C11,P$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(Q$10>=$C11,Q$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(R$10>=$C11,R$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(S$10>=$C11,S$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(T$10>=$C11,T$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(U$10>=$C11,U$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(V$10>=$C11,V$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(W$10>=$C11,W$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(X$10>=$C11,X$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(Y$10>=$C11,Y$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(Z$10>=$C11,Z$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AA$10>=$C11,AA$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AB$10>=$C11,AB$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AC$10>=$C11,AC$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AD$10>=$C11,AD$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AE$10>=$C11,AE$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AF$10>=$C11,AF$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AG$10>=$C11,AG$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AH$10>=$C11,AH$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AI$10>=$C11,AI$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AJ$10>=$C11,AJ$10<=$D11),1,"")) | =IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AK$10>=$C11,AK$10<=$D11),1,"")) | |
| 12 | 2 | Монтаж трасс | 27.10.2026 | 03.11.2026 | =IF(B12="","",IF(OR(NOT(ISNUMBER(C12)),NOT(ISNUMBER(D12))),"Нет дат",IF(D12<C12,"Ошибка дат",D12-C12+1))) | 25% | Подрядчик | Этап 1 | =IF(B12="","",IF(OR(NOT(ISNUMBER(C12)),NOT(ISNUMBER(D12)),NOT(ISNUMBER(F12))),"Нет данных",IF(D12<C12,"Ошибка дат",IF(F12=1,"Завершен",IF(D12<$B$5,"Просрочен","В работе"))))) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(J$10>=$C12,J$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(K$10>=$C12,K$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(L$10>=$C12,L$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(M$10>=$C12,M$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(N$10>=$C12,N$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(O$10>=$C12,O$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(P$10>=$C12,P$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(Q$10>=$C12,Q$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(R$10>=$C12,R$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(S$10>=$C12,S$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(T$10>=$C12,T$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(U$10>=$C12,U$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(V$10>=$C12,V$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(W$10>=$C12,W$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(X$10>=$C12,X$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(Y$10>=$C12,Y$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(Z$10>=$C12,Z$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AA$10>=$C12,AA$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AB$10>=$C12,AB$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AC$10>=$C12,AC$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AD$10>=$C12,AD$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AE$10>=$C12,AE$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AF$10>=$C12,AF$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AG$10>=$C12,AG$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AH$10>=$C12,AH$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AI$10>=$C12,AI$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AJ$10>=$C12,AJ$10<=$D12),1,"")) | =IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AK$10>=$C12,AK$10<=$D12),1,"")) |
| 13 | 3 | Испытания | 04.11.2026 | 06.11.2026 | =IF(B13="","",IF(OR(NOT(ISNUMBER(C13)),NOT(ISNUMBER(D13))),"Нет дат",IF(D13<C13,"Ошибка дат",D13-C13+1))) | 0% | Наладчик | Этап 2 | =IF(B13="","",IF(OR(NOT(ISNUMBER(C13)),NOT(ISNUMBER(D13)),NOT(ISNUMBER(F13))),"Нет данных",IF(D13<C13,"Ошибка дат",IF(F13=1,"Завершен",IF(D13<$B$5,"Просрочен","В работе"))))) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(J$10>=$C13,J$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(K$10>=$C13,K$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(L$10>=$C13,L$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(M$10>=$C13,M$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(N$10>=$C13,N$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(O$10>=$C13,O$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(P$10>=$C13,P$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(Q$10>=$C13,Q$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(R$10>=$C13,R$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(S$10>=$C13,S$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(T$10>=$C13,T$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(U$10>=$C13,U$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(V$10>=$C13,V$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(W$10>=$C13,W$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(X$10>=$C13,X$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(Y$10>=$C13,Y$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(Z$10>=$C13,Z$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AA$10>=$C13,AA$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AB$10>=$C13,AB$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AC$10>=$C13,AC$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AD$10>=$C13,AD$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AE$10>=$C13,AE$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AF$10>=$C13,AF$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AG$10>=$C13,AG$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AH$10>=$C13,AH$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AI$10>=$C13,AI$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AJ$10>=$C13,AJ$10<=$D13),1,"")) | =IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AK$10>=$C13,AK$10<=$D13),1,"")) |
| 14 | 4 | =IF(B14="","",IF(OR(NOT(ISNUMBER(C14)),NOT(ISNUMBER(D14))),"Нет дат",IF(D14<C14,"Ошибка дат",D14-C14+1))) | =IF(B14="","",IF(OR(NOT(ISNUMBER(C14)),NOT(ISNUMBER(D14)),NOT(ISNUMBER(F14))),"Нет данных",IF(D14<C14,"Ошибка дат",IF(F14=1,"Завершен",IF(D14<$B$5,"Просрочен","В работе"))))) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(J$10>=$C14,J$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(K$10>=$C14,K$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(L$10>=$C14,L$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(M$10>=$C14,M$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(N$10>=$C14,N$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(O$10>=$C14,O$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(P$10>=$C14,P$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(Q$10>=$C14,Q$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(R$10>=$C14,R$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(S$10>=$C14,S$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(T$10>=$C14,T$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(U$10>=$C14,U$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(V$10>=$C14,V$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(W$10>=$C14,W$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(X$10>=$C14,X$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(Y$10>=$C14,Y$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(Z$10>=$C14,Z$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AA$10>=$C14,AA$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AB$10>=$C14,AB$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AC$10>=$C14,AC$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AD$10>=$C14,AD$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AE$10>=$C14,AE$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AF$10>=$C14,AF$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AG$10>=$C14,AG$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AH$10>=$C14,AH$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AI$10>=$C14,AI$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AJ$10>=$C14,AJ$10<=$D14),1,"")) | =IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AK$10>=$C14,AK$10<=$D14),1,"")) | ||||||
| 15 | 5 | =IF(B15="","",IF(OR(NOT(ISNUMBER(C15)),NOT(ISNUMBER(D15))),"Нет дат",IF(D15<C15,"Ошибка дат",D15-C15+1))) | =IF(B15="","",IF(OR(NOT(ISNUMBER(C15)),NOT(ISNUMBER(D15)),NOT(ISNUMBER(F15))),"Нет данных",IF(D15<C15,"Ошибка дат",IF(F15=1,"Завершен",IF(D15<$B$5,"Просрочен","В работе"))))) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(J$10>=$C15,J$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(K$10>=$C15,K$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(L$10>=$C15,L$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(M$10>=$C15,M$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(N$10>=$C15,N$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(O$10>=$C15,O$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(P$10>=$C15,P$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(Q$10>=$C15,Q$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(R$10>=$C15,R$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(S$10>=$C15,S$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(T$10>=$C15,T$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(U$10>=$C15,U$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(V$10>=$C15,V$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(W$10>=$C15,W$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(X$10>=$C15,X$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(Y$10>=$C15,Y$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(Z$10>=$C15,Z$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AA$10>=$C15,AA$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AB$10>=$C15,AB$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AC$10>=$C15,AC$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AD$10>=$C15,AD$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AE$10>=$C15,AE$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AF$10>=$C15,AF$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AG$10>=$C15,AG$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AH$10>=$C15,AH$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AI$10>=$C15,AI$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AJ$10>=$C15,AJ$10<=$D15),1,"")) | =IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AK$10>=$C15,AK$10<=$D15),1,"")) | ||||||
| 16 | 6 | =IF(B16="","",IF(OR(NOT(ISNUMBER(C16)),NOT(ISNUMBER(D16))),"Нет дат",IF(D16<C16,"Ошибка дат",D16-C16+1))) | =IF(B16="","",IF(OR(NOT(ISNUMBER(C16)),NOT(ISNUMBER(D16)),NOT(ISNUMBER(F16))),"Нет данных",IF(D16<C16,"Ошибка дат",IF(F16=1,"Завершен",IF(D16<$B$5,"Просрочен","В работе"))))) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(J$10>=$C16,J$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(K$10>=$C16,K$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(L$10>=$C16,L$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(M$10>=$C16,M$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(N$10>=$C16,N$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(O$10>=$C16,O$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(P$10>=$C16,P$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(Q$10>=$C16,Q$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(R$10>=$C16,R$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(S$10>=$C16,S$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(T$10>=$C16,T$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(U$10>=$C16,U$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(V$10>=$C16,V$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(W$10>=$C16,W$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(X$10>=$C16,X$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(Y$10>=$C16,Y$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(Z$10>=$C16,Z$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AA$10>=$C16,AA$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AB$10>=$C16,AB$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AC$10>=$C16,AC$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AD$10>=$C16,AD$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AE$10>=$C16,AE$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AF$10>=$C16,AF$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AG$10>=$C16,AG$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AH$10>=$C16,AH$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AI$10>=$C16,AI$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AJ$10>=$C16,AJ$10<=$D16),1,"")) | =IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AK$10>=$C16,AK$10<=$D16),1,"")) | ||||||
| 17 | 7 | =IF(B17="","",IF(OR(NOT(ISNUMBER(C17)),NOT(ISNUMBER(D17))),"Нет дат",IF(D17<C17,"Ошибка дат",D17-C17+1))) | =IF(B17="","",IF(OR(NOT(ISNUMBER(C17)),NOT(ISNUMBER(D17)),NOT(ISNUMBER(F17))),"Нет данных",IF(D17<C17,"Ошибка дат",IF(F17=1,"Завершен",IF(D17<$B$5,"Просрочен","В работе"))))) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(J$10>=$C17,J$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(K$10>=$C17,K$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(L$10>=$C17,L$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(M$10>=$C17,M$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(N$10>=$C17,N$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(O$10>=$C17,O$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(P$10>=$C17,P$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(Q$10>=$C17,Q$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(R$10>=$C17,R$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(S$10>=$C17,S$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(T$10>=$C17,T$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(U$10>=$C17,U$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(V$10>=$C17,V$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(W$10>=$C17,W$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(X$10>=$C17,X$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(Y$10>=$C17,Y$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(Z$10>=$C17,Z$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AA$10>=$C17,AA$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AB$10>=$C17,AB$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AC$10>=$C17,AC$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AD$10>=$C17,AD$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AE$10>=$C17,AE$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AF$10>=$C17,AF$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AG$10>=$C17,AG$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AH$10>=$C17,AH$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AI$10>=$C17,AI$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AJ$10>=$C17,AJ$10<=$D17),1,"")) | =IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AK$10>=$C17,AK$10<=$D17),1,"")) | ||||||
| 18 | 8 | =IF(B18="","",IF(OR(NOT(ISNUMBER(C18)),NOT(ISNUMBER(D18))),"Нет дат",IF(D18<C18,"Ошибка дат",D18-C18+1))) | =IF(B18="","",IF(OR(NOT(ISNUMBER(C18)),NOT(ISNUMBER(D18)),NOT(ISNUMBER(F18))),"Нет данных",IF(D18<C18,"Ошибка дат",IF(F18=1,"Завершен",IF(D18<$B$5,"Просрочен","В работе"))))) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(J$10>=$C18,J$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(K$10>=$C18,K$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(L$10>=$C18,L$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(M$10>=$C18,M$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(N$10>=$C18,N$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(O$10>=$C18,O$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(P$10>=$C18,P$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(Q$10>=$C18,Q$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(R$10>=$C18,R$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(S$10>=$C18,S$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(T$10>=$C18,T$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(U$10>=$C18,U$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(V$10>=$C18,V$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(W$10>=$C18,W$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(X$10>=$C18,X$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(Y$10>=$C18,Y$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(Z$10>=$C18,Z$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AA$10>=$C18,AA$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AB$10>=$C18,AB$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AC$10>=$C18,AC$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AD$10>=$C18,AD$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AE$10>=$C18,AE$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AF$10>=$C18,AF$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AG$10>=$C18,AG$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AH$10>=$C18,AH$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AI$10>=$C18,AI$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AJ$10>=$C18,AJ$10<=$D18),1,"")) | =IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AK$10>=$C18,AK$10<=$D18),1,"")) | ||||||
| 19 | 9 | =IF(B19="","",IF(OR(NOT(ISNUMBER(C19)),NOT(ISNUMBER(D19))),"Нет дат",IF(D19<C19,"Ошибка дат",D19-C19+1))) | =IF(B19="","",IF(OR(NOT(ISNUMBER(C19)),NOT(ISNUMBER(D19)),NOT(ISNUMBER(F19))),"Нет данных",IF(D19<C19,"Ошибка дат",IF(F19=1,"Завершен",IF(D19<$B$5,"Просрочен","В работе"))))) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(J$10>=$C19,J$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(K$10>=$C19,K$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(L$10>=$C19,L$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(M$10>=$C19,M$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(N$10>=$C19,N$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(O$10>=$C19,O$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(P$10>=$C19,P$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(Q$10>=$C19,Q$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(R$10>=$C19,R$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(S$10>=$C19,S$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(T$10>=$C19,T$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(U$10>=$C19,U$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(V$10>=$C19,V$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(W$10>=$C19,W$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(X$10>=$C19,X$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(Y$10>=$C19,Y$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(Z$10>=$C19,Z$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AA$10>=$C19,AA$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AB$10>=$C19,AB$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AC$10>=$C19,AC$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AD$10>=$C19,AD$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AE$10>=$C19,AE$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AF$10>=$C19,AF$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AG$10>=$C19,AG$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AH$10>=$C19,AH$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AI$10>=$C19,AI$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AJ$10>=$C19,AJ$10<=$D19),1,"")) | =IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AK$10>=$C19,AK$10<=$D19),1,"")) | ||||||
| 20 | 10 | =IF(B20="","",IF(OR(NOT(ISNUMBER(C20)),NOT(ISNUMBER(D20))),"Нет дат",IF(D20<C20,"Ошибка дат",D20-C20+1))) | =IF(B20="","",IF(OR(NOT(ISNUMBER(C20)),NOT(ISNUMBER(D20)),NOT(ISNUMBER(F20))),"Нет данных",IF(D20<C20,"Ошибка дат",IF(F20=1,"Завершен",IF(D20<$B$5,"Просрочен","В работе"))))) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(J$10>=$C20,J$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(K$10>=$C20,K$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(L$10>=$C20,L$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(M$10>=$C20,M$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(N$10>=$C20,N$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(O$10>=$C20,O$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(P$10>=$C20,P$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(Q$10>=$C20,Q$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(R$10>=$C20,R$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(S$10>=$C20,S$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(T$10>=$C20,T$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(U$10>=$C20,U$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(V$10>=$C20,V$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(W$10>=$C20,W$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(X$10>=$C20,X$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(Y$10>=$C20,Y$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(Z$10>=$C20,Z$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AA$10>=$C20,AA$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AB$10>=$C20,AB$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AC$10>=$C20,AC$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AD$10>=$C20,AD$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AE$10>=$C20,AE$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AF$10>=$C20,AF$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AG$10>=$C20,AG$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AH$10>=$C20,AH$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AI$10>=$C20,AI$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AJ$10>=$C20,AJ$10<=$D20),1,"")) | =IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AK$10>=$C20,AK$10<=$D20),1,"")) | ||||||
| 21 | 11 | =IF(B21="","",IF(OR(NOT(ISNUMBER(C21)),NOT(ISNUMBER(D21))),"Нет дат",IF(D21<C21,"Ошибка дат",D21-C21+1))) | =IF(B21="","",IF(OR(NOT(ISNUMBER(C21)),NOT(ISNUMBER(D21)),NOT(ISNUMBER(F21))),"Нет данных",IF(D21<C21,"Ошибка дат",IF(F21=1,"Завершен",IF(D21<$B$5,"Просрочен","В работе"))))) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(J$10>=$C21,J$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(K$10>=$C21,K$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(L$10>=$C21,L$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(M$10>=$C21,M$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(N$10>=$C21,N$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(O$10>=$C21,O$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(P$10>=$C21,P$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(Q$10>=$C21,Q$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(R$10>=$C21,R$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(S$10>=$C21,S$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(T$10>=$C21,T$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(U$10>=$C21,U$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(V$10>=$C21,V$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(W$10>=$C21,W$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(X$10>=$C21,X$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(Y$10>=$C21,Y$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(Z$10>=$C21,Z$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AA$10>=$C21,AA$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AB$10>=$C21,AB$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AC$10>=$C21,AC$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AD$10>=$C21,AD$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AE$10>=$C21,AE$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AF$10>=$C21,AF$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AG$10>=$C21,AG$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AH$10>=$C21,AH$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AI$10>=$C21,AI$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AJ$10>=$C21,AJ$10<=$D21),1,"")) | =IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AK$10>=$C21,AK$10<=$D21),1,"")) | ||||||
| 22 | 12 | =IF(B22="","",IF(OR(NOT(ISNUMBER(C22)),NOT(ISNUMBER(D22))),"Нет дат",IF(D22<C22,"Ошибка дат",D22-C22+1))) | =IF(B22="","",IF(OR(NOT(ISNUMBER(C22)),NOT(ISNUMBER(D22)),NOT(ISNUMBER(F22))),"Нет данных",IF(D22<C22,"Ошибка дат",IF(F22=1,"Завершен",IF(D22<$B$5,"Просрочен","В работе"))))) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(J$10>=$C22,J$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(K$10>=$C22,K$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(L$10>=$C22,L$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(M$10>=$C22,M$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(N$10>=$C22,N$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(O$10>=$C22,O$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(P$10>=$C22,P$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(Q$10>=$C22,Q$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(R$10>=$C22,R$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(S$10>=$C22,S$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(T$10>=$C22,T$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(U$10>=$C22,U$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(V$10>=$C22,V$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(W$10>=$C22,W$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(X$10>=$C22,X$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(Y$10>=$C22,Y$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(Z$10>=$C22,Z$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AA$10>=$C22,AA$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AB$10>=$C22,AB$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AC$10>=$C22,AC$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AD$10>=$C22,AD$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AE$10>=$C22,AE$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AF$10>=$C22,AF$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AG$10>=$C22,AG$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AH$10>=$C22,AH$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AI$10>=$C22,AI$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AJ$10>=$C22,AJ$10<=$D22),1,"")) | =IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AK$10>=$C22,AK$10<=$D22),1,"")) | ||||||
| 23 | 13 | =IF(B23="","",IF(OR(NOT(ISNUMBER(C23)),NOT(ISNUMBER(D23))),"Нет дат",IF(D23<C23,"Ошибка дат",D23-C23+1))) | =IF(B23="","",IF(OR(NOT(ISNUMBER(C23)),NOT(ISNUMBER(D23)),NOT(ISNUMBER(F23))),"Нет данных",IF(D23<C23,"Ошибка дат",IF(F23=1,"Завершен",IF(D23<$B$5,"Просрочен","В работе"))))) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(J$10>=$C23,J$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(K$10>=$C23,K$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(L$10>=$C23,L$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(M$10>=$C23,M$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(N$10>=$C23,N$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(O$10>=$C23,O$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(P$10>=$C23,P$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(Q$10>=$C23,Q$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(R$10>=$C23,R$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(S$10>=$C23,S$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(T$10>=$C23,T$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(U$10>=$C23,U$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(V$10>=$C23,V$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(W$10>=$C23,W$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(X$10>=$C23,X$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(Y$10>=$C23,Y$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(Z$10>=$C23,Z$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AA$10>=$C23,AA$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AB$10>=$C23,AB$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AC$10>=$C23,AC$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AD$10>=$C23,AD$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AE$10>=$C23,AE$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AF$10>=$C23,AF$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AG$10>=$C23,AG$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AH$10>=$C23,AH$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AI$10>=$C23,AI$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AJ$10>=$C23,AJ$10<=$D23),1,"")) | =IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AK$10>=$C23,AK$10<=$D23),1,"")) | ||||||
| 24 | 14 | =IF(B24="","",IF(OR(NOT(ISNUMBER(C24)),NOT(ISNUMBER(D24))),"Нет дат",IF(D24<C24,"Ошибка дат",D24-C24+1))) | =IF(B24="","",IF(OR(NOT(ISNUMBER(C24)),NOT(ISNUMBER(D24)),NOT(ISNUMBER(F24))),"Нет данных",IF(D24<C24,"Ошибка дат",IF(F24=1,"Завершен",IF(D24<$B$5,"Просрочен","В работе"))))) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(J$10>=$C24,J$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(K$10>=$C24,K$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(L$10>=$C24,L$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(M$10>=$C24,M$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(N$10>=$C24,N$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(O$10>=$C24,O$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(P$10>=$C24,P$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(Q$10>=$C24,Q$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(R$10>=$C24,R$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(S$10>=$C24,S$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(T$10>=$C24,T$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(U$10>=$C24,U$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(V$10>=$C24,V$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(W$10>=$C24,W$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(X$10>=$C24,X$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(Y$10>=$C24,Y$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(Z$10>=$C24,Z$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AA$10>=$C24,AA$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AB$10>=$C24,AB$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AC$10>=$C24,AC$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AD$10>=$C24,AD$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AE$10>=$C24,AE$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AF$10>=$C24,AF$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AG$10>=$C24,AG$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AH$10>=$C24,AH$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AI$10>=$C24,AI$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AJ$10>=$C24,AJ$10<=$D24),1,"")) | =IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AK$10>=$C24,AK$10<=$D24),1,"")) | ||||||
| 25 | 15 | =IF(B25="","",IF(OR(NOT(ISNUMBER(C25)),NOT(ISNUMBER(D25))),"Нет дат",IF(D25<C25,"Ошибка дат",D25-C25+1))) | =IF(B25="","",IF(OR(NOT(ISNUMBER(C25)),NOT(ISNUMBER(D25)),NOT(ISNUMBER(F25))),"Нет данных",IF(D25<C25,"Ошибка дат",IF(F25=1,"Завершен",IF(D25<$B$5,"Просрочен","В работе"))))) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(J$10>=$C25,J$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(K$10>=$C25,K$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(L$10>=$C25,L$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(M$10>=$C25,M$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(N$10>=$C25,N$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(O$10>=$C25,O$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(P$10>=$C25,P$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(Q$10>=$C25,Q$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(R$10>=$C25,R$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(S$10>=$C25,S$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(T$10>=$C25,T$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(U$10>=$C25,U$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(V$10>=$C25,V$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(W$10>=$C25,W$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(X$10>=$C25,X$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(Y$10>=$C25,Y$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(Z$10>=$C25,Z$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AA$10>=$C25,AA$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AB$10>=$C25,AB$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AC$10>=$C25,AC$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AD$10>=$C25,AD$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AE$10>=$C25,AE$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AF$10>=$C25,AF$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AG$10>=$C25,AG$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AH$10>=$C25,AH$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AI$10>=$C25,AI$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AJ$10>=$C25,AJ$10<=$D25),1,"")) | =IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AK$10>=$C25,AK$10<=$D25),1,"")) | ||||||
| 26 | 16 | =IF(B26="","",IF(OR(NOT(ISNUMBER(C26)),NOT(ISNUMBER(D26))),"Нет дат",IF(D26<C26,"Ошибка дат",D26-C26+1))) | =IF(B26="","",IF(OR(NOT(ISNUMBER(C26)),NOT(ISNUMBER(D26)),NOT(ISNUMBER(F26))),"Нет данных",IF(D26<C26,"Ошибка дат",IF(F26=1,"Завершен",IF(D26<$B$5,"Просрочен","В работе"))))) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(J$10>=$C26,J$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(K$10>=$C26,K$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(L$10>=$C26,L$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(M$10>=$C26,M$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(N$10>=$C26,N$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(O$10>=$C26,O$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(P$10>=$C26,P$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(Q$10>=$C26,Q$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(R$10>=$C26,R$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(S$10>=$C26,S$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(T$10>=$C26,T$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(U$10>=$C26,U$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(V$10>=$C26,V$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(W$10>=$C26,W$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(X$10>=$C26,X$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(Y$10>=$C26,Y$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(Z$10>=$C26,Z$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AA$10>=$C26,AA$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AB$10>=$C26,AB$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AC$10>=$C26,AC$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AD$10>=$C26,AD$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AE$10>=$C26,AE$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AF$10>=$C26,AF$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AG$10>=$C26,AG$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AH$10>=$C26,AH$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AI$10>=$C26,AI$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AJ$10>=$C26,AJ$10<=$D26),1,"")) | =IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AK$10>=$C26,AK$10<=$D26),1,"")) | ||||||
| 27 | 17 | =IF(B27="","",IF(OR(NOT(ISNUMBER(C27)),NOT(ISNUMBER(D27))),"Нет дат",IF(D27<C27,"Ошибка дат",D27-C27+1))) | =IF(B27="","",IF(OR(NOT(ISNUMBER(C27)),NOT(ISNUMBER(D27)),NOT(ISNUMBER(F27))),"Нет данных",IF(D27<C27,"Ошибка дат",IF(F27=1,"Завершен",IF(D27<$B$5,"Просрочен","В работе"))))) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(J$10>=$C27,J$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(K$10>=$C27,K$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(L$10>=$C27,L$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(M$10>=$C27,M$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(N$10>=$C27,N$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(O$10>=$C27,O$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(P$10>=$C27,P$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(Q$10>=$C27,Q$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(R$10>=$C27,R$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(S$10>=$C27,S$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(T$10>=$C27,T$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(U$10>=$C27,U$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(V$10>=$C27,V$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(W$10>=$C27,W$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(X$10>=$C27,X$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(Y$10>=$C27,Y$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(Z$10>=$C27,Z$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AA$10>=$C27,AA$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AB$10>=$C27,AB$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AC$10>=$C27,AC$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AD$10>=$C27,AD$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AE$10>=$C27,AE$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AF$10>=$C27,AF$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AG$10>=$C27,AG$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AH$10>=$C27,AH$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AI$10>=$C27,AI$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AJ$10>=$C27,AJ$10<=$D27),1,"")) | =IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AK$10>=$C27,AK$10<=$D27),1,"")) | ||||||
| 28 | 18 | =IF(B28="","",IF(OR(NOT(ISNUMBER(C28)),NOT(ISNUMBER(D28))),"Нет дат",IF(D28<C28,"Ошибка дат",D28-C28+1))) | =IF(B28="","",IF(OR(NOT(ISNUMBER(C28)),NOT(ISNUMBER(D28)),NOT(ISNUMBER(F28))),"Нет данных",IF(D28<C28,"Ошибка дат",IF(F28=1,"Завершен",IF(D28<$B$5,"Просрочен","В работе"))))) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(J$10>=$C28,J$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(K$10>=$C28,K$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(L$10>=$C28,L$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(M$10>=$C28,M$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(N$10>=$C28,N$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(O$10>=$C28,O$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(P$10>=$C28,P$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(Q$10>=$C28,Q$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(R$10>=$C28,R$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(S$10>=$C28,S$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(T$10>=$C28,T$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(U$10>=$C28,U$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(V$10>=$C28,V$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(W$10>=$C28,W$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(X$10>=$C28,X$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(Y$10>=$C28,Y$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(Z$10>=$C28,Z$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AA$10>=$C28,AA$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AB$10>=$C28,AB$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AC$10>=$C28,AC$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AD$10>=$C28,AD$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AE$10>=$C28,AE$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AF$10>=$C28,AF$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AG$10>=$C28,AG$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AH$10>=$C28,AH$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AI$10>=$C28,AI$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AJ$10>=$C28,AJ$10<=$D28),1,"")) | =IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AK$10>=$C28,AK$10<=$D28),1,"")) | ||||||
| 29 | 19 | =IF(B29="","",IF(OR(NOT(ISNUMBER(C29)),NOT(ISNUMBER(D29))),"Нет дат",IF(D29<C29,"Ошибка дат",D29-C29+1))) | =IF(B29="","",IF(OR(NOT(ISNUMBER(C29)),NOT(ISNUMBER(D29)),NOT(ISNUMBER(F29))),"Нет данных",IF(D29<C29,"Ошибка дат",IF(F29=1,"Завершен",IF(D29<$B$5,"Просрочен","В работе"))))) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(J$10>=$C29,J$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(K$10>=$C29,K$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(L$10>=$C29,L$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(M$10>=$C29,M$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(N$10>=$C29,N$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(O$10>=$C29,O$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(P$10>=$C29,P$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(Q$10>=$C29,Q$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(R$10>=$C29,R$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(S$10>=$C29,S$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(T$10>=$C29,T$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(U$10>=$C29,U$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(V$10>=$C29,V$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(W$10>=$C29,W$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(X$10>=$C29,X$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(Y$10>=$C29,Y$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(Z$10>=$C29,Z$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AA$10>=$C29,AA$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AB$10>=$C29,AB$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AC$10>=$C29,AC$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AD$10>=$C29,AD$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AE$10>=$C29,AE$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AF$10>=$C29,AF$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AG$10>=$C29,AG$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AH$10>=$C29,AH$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AI$10>=$C29,AI$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AJ$10>=$C29,AJ$10<=$D29),1,"")) | =IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AK$10>=$C29,AK$10<=$D29),1,"")) | ||||||
| 30 | 20 | =IF(B30="","",IF(OR(NOT(ISNUMBER(C30)),NOT(ISNUMBER(D30))),"Нет дат",IF(D30<C30,"Ошибка дат",D30-C30+1))) | =IF(B30="","",IF(OR(NOT(ISNUMBER(C30)),NOT(ISNUMBER(D30)),NOT(ISNUMBER(F30))),"Нет данных",IF(D30<C30,"Ошибка дат",IF(F30=1,"Завершен",IF(D30<$B$5,"Просрочен","В работе"))))) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(J$10>=$C30,J$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(K$10>=$C30,K$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(L$10>=$C30,L$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(M$10>=$C30,M$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(N$10>=$C30,N$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(O$10>=$C30,O$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(P$10>=$C30,P$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(Q$10>=$C30,Q$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(R$10>=$C30,R$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(S$10>=$C30,S$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(T$10>=$C30,T$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(U$10>=$C30,U$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(V$10>=$C30,V$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(W$10>=$C30,W$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(X$10>=$C30,X$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(Y$10>=$C30,Y$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(Z$10>=$C30,Z$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AA$10>=$C30,AA$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AB$10>=$C30,AB$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AC$10>=$C30,AC$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AD$10>=$C30,AD$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AE$10>=$C30,AE$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AF$10>=$C30,AF$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AG$10>=$C30,AG$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AH$10>=$C30,AH$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AI$10>=$C30,AI$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AJ$10>=$C30,AJ$10<=$D30),1,"")) | =IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AK$10>=$C30,AK$10<=$D30),1,"")) | ||||||
| 31 | 21 | =IF(B31="","",IF(OR(NOT(ISNUMBER(C31)),NOT(ISNUMBER(D31))),"Нет дат",IF(D31<C31,"Ошибка дат",D31-C31+1))) | =IF(B31="","",IF(OR(NOT(ISNUMBER(C31)),NOT(ISNUMBER(D31)),NOT(ISNUMBER(F31))),"Нет данных",IF(D31<C31,"Ошибка дат",IF(F31=1,"Завершен",IF(D31<$B$5,"Просрочен","В работе"))))) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(J$10>=$C31,J$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(K$10>=$C31,K$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(L$10>=$C31,L$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(M$10>=$C31,M$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(N$10>=$C31,N$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(O$10>=$C31,O$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(P$10>=$C31,P$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(Q$10>=$C31,Q$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(R$10>=$C31,R$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(S$10>=$C31,S$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(T$10>=$C31,T$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(U$10>=$C31,U$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(V$10>=$C31,V$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(W$10>=$C31,W$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(X$10>=$C31,X$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(Y$10>=$C31,Y$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(Z$10>=$C31,Z$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AA$10>=$C31,AA$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AB$10>=$C31,AB$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AC$10>=$C31,AC$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AD$10>=$C31,AD$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AE$10>=$C31,AE$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AF$10>=$C31,AF$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AG$10>=$C31,AG$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AH$10>=$C31,AH$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AI$10>=$C31,AI$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AJ$10>=$C31,AJ$10<=$D31),1,"")) | =IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AK$10>=$C31,AK$10<=$D31),1,"")) | ||||||
| 32 | 22 | =IF(B32="","",IF(OR(NOT(ISNUMBER(C32)),NOT(ISNUMBER(D32))),"Нет дат",IF(D32<C32,"Ошибка дат",D32-C32+1))) | =IF(B32="","",IF(OR(NOT(ISNUMBER(C32)),NOT(ISNUMBER(D32)),NOT(ISNUMBER(F32))),"Нет данных",IF(D32<C32,"Ошибка дат",IF(F32=1,"Завершен",IF(D32<$B$5,"Просрочен","В работе"))))) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(J$10>=$C32,J$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(K$10>=$C32,K$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(L$10>=$C32,L$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(M$10>=$C32,M$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(N$10>=$C32,N$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(O$10>=$C32,O$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(P$10>=$C32,P$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(Q$10>=$C32,Q$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(R$10>=$C32,R$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(S$10>=$C32,S$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(T$10>=$C32,T$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(U$10>=$C32,U$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(V$10>=$C32,V$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(W$10>=$C32,W$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(X$10>=$C32,X$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(Y$10>=$C32,Y$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(Z$10>=$C32,Z$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AA$10>=$C32,AA$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AB$10>=$C32,AB$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AC$10>=$C32,AC$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AD$10>=$C32,AD$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AE$10>=$C32,AE$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AF$10>=$C32,AF$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AG$10>=$C32,AG$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AH$10>=$C32,AH$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AI$10>=$C32,AI$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AJ$10>=$C32,AJ$10<=$D32),1,"")) | =IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AK$10>=$C32,AK$10<=$D32),1,"")) | ||||||
| 33 | 23 | =IF(B33="","",IF(OR(NOT(ISNUMBER(C33)),NOT(ISNUMBER(D33))),"Нет дат",IF(D33<C33,"Ошибка дат",D33-C33+1))) | =IF(B33="","",IF(OR(NOT(ISNUMBER(C33)),NOT(ISNUMBER(D33)),NOT(ISNUMBER(F33))),"Нет данных",IF(D33<C33,"Ошибка дат",IF(F33=1,"Завершен",IF(D33<$B$5,"Просрочен","В работе"))))) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(J$10>=$C33,J$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(K$10>=$C33,K$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(L$10>=$C33,L$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(M$10>=$C33,M$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(N$10>=$C33,N$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(O$10>=$C33,O$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(P$10>=$C33,P$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(Q$10>=$C33,Q$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(R$10>=$C33,R$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(S$10>=$C33,S$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(T$10>=$C33,T$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(U$10>=$C33,U$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(V$10>=$C33,V$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(W$10>=$C33,W$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(X$10>=$C33,X$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(Y$10>=$C33,Y$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(Z$10>=$C33,Z$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AA$10>=$C33,AA$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AB$10>=$C33,AB$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AC$10>=$C33,AC$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AD$10>=$C33,AD$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AE$10>=$C33,AE$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AF$10>=$C33,AF$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AG$10>=$C33,AG$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AH$10>=$C33,AH$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AI$10>=$C33,AI$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AJ$10>=$C33,AJ$10<=$D33),1,"")) | =IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AK$10>=$C33,AK$10<=$D33),1,"")) | ||||||
| 34 | 24 | =IF(B34="","",IF(OR(NOT(ISNUMBER(C34)),NOT(ISNUMBER(D34))),"Нет дат",IF(D34<C34,"Ошибка дат",D34-C34+1))) | =IF(B34="","",IF(OR(NOT(ISNUMBER(C34)),NOT(ISNUMBER(D34)),NOT(ISNUMBER(F34))),"Нет данных",IF(D34<C34,"Ошибка дат",IF(F34=1,"Завершен",IF(D34<$B$5,"Просрочен","В работе"))))) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(J$10>=$C34,J$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(K$10>=$C34,K$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(L$10>=$C34,L$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(M$10>=$C34,M$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(N$10>=$C34,N$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(O$10>=$C34,O$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(P$10>=$C34,P$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(Q$10>=$C34,Q$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(R$10>=$C34,R$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(S$10>=$C34,S$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(T$10>=$C34,T$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(U$10>=$C34,U$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(V$10>=$C34,V$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(W$10>=$C34,W$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(X$10>=$C34,X$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(Y$10>=$C34,Y$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(Z$10>=$C34,Z$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AA$10>=$C34,AA$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AB$10>=$C34,AB$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AC$10>=$C34,AC$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AD$10>=$C34,AD$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AE$10>=$C34,AE$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AF$10>=$C34,AF$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AG$10>=$C34,AG$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AH$10>=$C34,AH$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AI$10>=$C34,AI$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AJ$10>=$C34,AJ$10<=$D34),1,"")) | =IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AK$10>=$C34,AK$10<=$D34),1,"")) | ||||||
| 35 | 25 | =IF(B35="","",IF(OR(NOT(ISNUMBER(C35)),NOT(ISNUMBER(D35))),"Нет дат",IF(D35<C35,"Ошибка дат",D35-C35+1))) | =IF(B35="","",IF(OR(NOT(ISNUMBER(C35)),NOT(ISNUMBER(D35)),NOT(ISNUMBER(F35))),"Нет данных",IF(D35<C35,"Ошибка дат",IF(F35=1,"Завершен",IF(D35<$B$5,"Просрочен","В работе"))))) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(J$10>=$C35,J$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(K$10>=$C35,K$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(L$10>=$C35,L$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(M$10>=$C35,M$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(N$10>=$C35,N$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(O$10>=$C35,O$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(P$10>=$C35,P$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(Q$10>=$C35,Q$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(R$10>=$C35,R$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(S$10>=$C35,S$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(T$10>=$C35,T$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(U$10>=$C35,U$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(V$10>=$C35,V$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(W$10>=$C35,W$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(X$10>=$C35,X$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(Y$10>=$C35,Y$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(Z$10>=$C35,Z$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AA$10>=$C35,AA$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AB$10>=$C35,AB$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AC$10>=$C35,AC$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AD$10>=$C35,AD$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AE$10>=$C35,AE$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AF$10>=$C35,AF$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AG$10>=$C35,AG$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AH$10>=$C35,AH$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AI$10>=$C35,AI$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AJ$10>=$C35,AJ$10<=$D35),1,"")) | =IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AK$10>=$C35,AK$10<=$D35),1,"")) | ||||||
| 36 | 26 | =IF(B36="","",IF(OR(NOT(ISNUMBER(C36)),NOT(ISNUMBER(D36))),"Нет дат",IF(D36<C36,"Ошибка дат",D36-C36+1))) | =IF(B36="","",IF(OR(NOT(ISNUMBER(C36)),NOT(ISNUMBER(D36)),NOT(ISNUMBER(F36))),"Нет данных",IF(D36<C36,"Ошибка дат",IF(F36=1,"Завершен",IF(D36<$B$5,"Просрочен","В работе"))))) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(J$10>=$C36,J$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(K$10>=$C36,K$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(L$10>=$C36,L$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(M$10>=$C36,M$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(N$10>=$C36,N$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(O$10>=$C36,O$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(P$10>=$C36,P$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(Q$10>=$C36,Q$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(R$10>=$C36,R$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(S$10>=$C36,S$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(T$10>=$C36,T$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(U$10>=$C36,U$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(V$10>=$C36,V$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(W$10>=$C36,W$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(X$10>=$C36,X$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(Y$10>=$C36,Y$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(Z$10>=$C36,Z$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AA$10>=$C36,AA$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AB$10>=$C36,AB$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AC$10>=$C36,AC$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AD$10>=$C36,AD$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AE$10>=$C36,AE$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AF$10>=$C36,AF$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AG$10>=$C36,AG$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AH$10>=$C36,AH$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AI$10>=$C36,AI$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AJ$10>=$C36,AJ$10<=$D36),1,"")) | =IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AK$10>=$C36,AK$10<=$D36),1,"")) | ||||||
| 37 | 27 | =IF(B37="","",IF(OR(NOT(ISNUMBER(C37)),NOT(ISNUMBER(D37))),"Нет дат",IF(D37<C37,"Ошибка дат",D37-C37+1))) | =IF(B37="","",IF(OR(NOT(ISNUMBER(C37)),NOT(ISNUMBER(D37)),NOT(ISNUMBER(F37))),"Нет данных",IF(D37<C37,"Ошибка дат",IF(F37=1,"Завершен",IF(D37<$B$5,"Просрочен","В работе"))))) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(J$10>=$C37,J$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(K$10>=$C37,K$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(L$10>=$C37,L$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(M$10>=$C37,M$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(N$10>=$C37,N$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(O$10>=$C37,O$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(P$10>=$C37,P$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(Q$10>=$C37,Q$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(R$10>=$C37,R$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(S$10>=$C37,S$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(T$10>=$C37,T$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(U$10>=$C37,U$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(V$10>=$C37,V$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(W$10>=$C37,W$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(X$10>=$C37,X$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(Y$10>=$C37,Y$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(Z$10>=$C37,Z$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AA$10>=$C37,AA$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AB$10>=$C37,AB$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AC$10>=$C37,AC$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AD$10>=$C37,AD$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AE$10>=$C37,AE$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AF$10>=$C37,AF$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AG$10>=$C37,AG$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AH$10>=$C37,AH$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AI$10>=$C37,AI$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AJ$10>=$C37,AJ$10<=$D37),1,"")) | =IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AK$10>=$C37,AK$10<=$D37),1,"")) | ||||||
| 38 | 28 | =IF(B38="","",IF(OR(NOT(ISNUMBER(C38)),NOT(ISNUMBER(D38))),"Нет дат",IF(D38<C38,"Ошибка дат",D38-C38+1))) | =IF(B38="","",IF(OR(NOT(ISNUMBER(C38)),NOT(ISNUMBER(D38)),NOT(ISNUMBER(F38))),"Нет данных",IF(D38<C38,"Ошибка дат",IF(F38=1,"Завершен",IF(D38<$B$5,"Просрочен","В работе"))))) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(J$10>=$C38,J$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(K$10>=$C38,K$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(L$10>=$C38,L$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(M$10>=$C38,M$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(N$10>=$C38,N$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(O$10>=$C38,O$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(P$10>=$C38,P$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(Q$10>=$C38,Q$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(R$10>=$C38,R$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(S$10>=$C38,S$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(T$10>=$C38,T$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(U$10>=$C38,U$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(V$10>=$C38,V$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(W$10>=$C38,W$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(X$10>=$C38,X$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(Y$10>=$C38,Y$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(Z$10>=$C38,Z$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AA$10>=$C38,AA$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AB$10>=$C38,AB$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AC$10>=$C38,AC$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AD$10>=$C38,AD$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AE$10>=$C38,AE$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AF$10>=$C38,AF$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AG$10>=$C38,AG$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AH$10>=$C38,AH$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AI$10>=$C38,AI$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AJ$10>=$C38,AJ$10<=$D38),1,"")) | =IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AK$10>=$C38,AK$10<=$D38),1,"")) | ||||||
| 39 | 29 | =IF(B39="","",IF(OR(NOT(ISNUMBER(C39)),NOT(ISNUMBER(D39))),"Нет дат",IF(D39<C39,"Ошибка дат",D39-C39+1))) | =IF(B39="","",IF(OR(NOT(ISNUMBER(C39)),NOT(ISNUMBER(D39)),NOT(ISNUMBER(F39))),"Нет данных",IF(D39<C39,"Ошибка дат",IF(F39=1,"Завершен",IF(D39<$B$5,"Просрочен","В работе"))))) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(J$10>=$C39,J$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(K$10>=$C39,K$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(L$10>=$C39,L$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(M$10>=$C39,M$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(N$10>=$C39,N$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(O$10>=$C39,O$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(P$10>=$C39,P$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(Q$10>=$C39,Q$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(R$10>=$C39,R$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(S$10>=$C39,S$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(T$10>=$C39,T$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(U$10>=$C39,U$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(V$10>=$C39,V$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(W$10>=$C39,W$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(X$10>=$C39,X$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(Y$10>=$C39,Y$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(Z$10>=$C39,Z$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AA$10>=$C39,AA$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AB$10>=$C39,AB$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AC$10>=$C39,AC$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AD$10>=$C39,AD$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AE$10>=$C39,AE$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AF$10>=$C39,AF$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AG$10>=$C39,AG$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AH$10>=$C39,AH$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AI$10>=$C39,AI$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AJ$10>=$C39,AJ$10<=$D39),1,"")) | =IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AK$10>=$C39,AK$10<=$D39),1,"")) | ||||||
| 40 | 30 | =IF(B40="","",IF(OR(NOT(ISNUMBER(C40)),NOT(ISNUMBER(D40))),"Нет дат",IF(D40<C40,"Ошибка дат",D40-C40+1))) | =IF(B40="","",IF(OR(NOT(ISNUMBER(C40)),NOT(ISNUMBER(D40)),NOT(ISNUMBER(F40))),"Нет данных",IF(D40<C40,"Ошибка дат",IF(F40=1,"Завершен",IF(D40<$B$5,"Просрочен","В работе"))))) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(J$10>=$C40,J$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(K$10>=$C40,K$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(L$10>=$C40,L$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(M$10>=$C40,M$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(N$10>=$C40,N$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(O$10>=$C40,O$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(P$10>=$C40,P$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(Q$10>=$C40,Q$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(R$10>=$C40,R$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(S$10>=$C40,S$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(T$10>=$C40,T$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(U$10>=$C40,U$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(V$10>=$C40,V$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(W$10>=$C40,W$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(X$10>=$C40,X$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(Y$10>=$C40,Y$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(Z$10>=$C40,Z$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AA$10>=$C40,AA$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AB$10>=$C40,AB$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AC$10>=$C40,AC$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AD$10>=$C40,AD$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AE$10>=$C40,AE$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AF$10>=$C40,AF$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AG$10>=$C40,AG$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AH$10>=$C40,AH$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AI$10>=$C40,AI$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AJ$10>=$C40,AJ$10<=$D40),1,"")) | =IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AK$10>=$C40,AK$10<=$D40),1,"")) |

