その他
xn--t8j3bz04sl3w.xyz
=SORT(UNIQUE(TOCOL(Sheet1!A:A,1)))
=IF(C2="","",IF(C2>=TIMEVALUE("17:00"),WORKDAY.INTL(B2,6,1,E3:E5),WORKDAY.INTL(B2,5,1,E3:E5)))
xn--t8j3bz04sl3w.xyz
=SORT(UNIQUE(TOCOL(Sheet1!A:A,1)))
=IF(C2="","",IF(C2>=TIMEVALUE("17:00"),WORKDAY.INTL(B2,6,1,E3:E5),WORKDAY.INTL(B2,5,1,E3:E5)))