=IF( ISERROR(WEEKDAY("20" & LEFT(TRIM($G$8),2)&"/"& $B$1& "/" &A12)),"",WEEKDAY("20" & LEFT(TRIM($G$8),2)&"/"& $B$1 & "/" &A12)) |
Excel WEEKDAY関数で曜日に
Standardexcel
叶茂盛
记一记
=IF( ISERROR(WEEKDAY("20" & LEFT(TRIM($G$8),2)&"/"& $B$1& "/" &A12)),"",WEEKDAY("20" & LEFT(TRIM($G$8),2)&"/"& $B$1 & "/" &A12)) |