質問編集履歴
2
A1参照で確認し式を修正しました
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -6,7 +6,7 @@
|
|
|
6
6
|
|
|
7
7
|
```
|
|
8
8
|
|
|
9
|
-
var fml = '=AND(Today()-Workday(R[0]C[-1],10,
|
|
9
|
+
var fml = '=AND(Today()-Workday(R[0]C[-1],10,'祝日判定'!A:A))' ;
|
|
10
10
|
|
|
11
11
|
for(var i=2; i<=end_row; i++){
|
|
12
12
|
|
1
該当のスクリプト部分追記いたしました。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -6,7 +6,13 @@
|
|
|
6
6
|
|
|
7
7
|
```
|
|
8
8
|
|
|
9
|
-
=AND(Today()-Workday(R[0]C[-1],10,¥'祝日判定!¥'A:A))"' ;
|
|
9
|
+
var fml = '=AND(Today()-Workday(R[0]C[-1],10,¥'祝日判定!¥'A:A))"' ;
|
|
10
|
+
|
|
11
|
+
for(var i=2; i<=end_row; i++){
|
|
12
|
+
|
|
13
|
+
sheet.getRange(i, 56).SetFormulaR1C1(fml);
|
|
14
|
+
|
|
15
|
+
|
|
10
16
|
|
|
11
17
|
```
|
|
12
18
|
|