回答編集履歴
1
追記
test
CHANGED
|
@@ -36,6 +36,18 @@
|
|
|
36
36
|
|
|
37
37
|
```EXCEL
|
|
38
38
|
|
|
39
|
-
=IF(ISNA(VLOOKUP(F4,$B$4:$B$
|
|
39
|
+
=IF(ISNA(VLOOKUP(F4,$B$4:$B$30,1,FALSE)),IF(J4=7,"指定休日",IF(J4=1,"休日","営業日")),"休日")
|
|
40
40
|
|
|
41
41
|
```
|
|
42
|
+
|
|
43
|
+
|
|
44
|
+
|
|
45
|
+
最近のバージョンなら、
|
|
46
|
+
|
|
47
|
+
|
|
48
|
+
|
|
49
|
+
```EXCEL
|
|
50
|
+
|
|
51
|
+
=IFS(OR(XLOOKUP(F4,$B$4:$B$30,$B$4:$B$30,0)<>0,J4=1),"休日",J4=7,"指定休日",TRUE,"営業日")
|
|
52
|
+
|
|
53
|
+
```
|