VBAEXCEL}Ng  .Formula@

@VBAŃGXCEĽvZZɐݒ肷 @.Formula@
https://www.tipsfound.com/vba/07003-vba 

Range("A1").Formula = "=SUM(A2:A3)"  
Cells(2, 1).Formula = "=SUM(B1:B2)"  


AVBAŏZɐݒ肷 
https://excel-ubara.com/excelvba1/EXCELVBA331.html 

jJ}؂0TvX 
_uNH[e[V̓GXP[v
Range.NumberFormatLocal = "#,###""yy/m/d""T"""

j
Sheet1.Range("AA" & inp_idx1).NumberFormatLocal = "yy/m/d""T"""


TvuΏۏTvEXCEL̃}NŌvZ 

Sheet1.Range("AA" & inp_idx1).Formula = "=INT(BE" & inp_idx1 & ")-WEEKDAY(BE" & inp_idx1 & ",2)+1 " 
Sheet1.Range("AA" & inp_idx1).NumberFormatLocal = "yy/m/d""T"""   

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/  

EXCEL}N̏t̃mbgOȐ

EXCELt̃mbgOȐ 
@=OR (1,2)Ɛ͂ 

A=AND (1,2)  =NOT($A2="A")v̑Ɂu=$A2<>"A"vƂsg 
@=AND (<>"0",<>"0") =AND (NOT("0"),NOT("0"))