每月非周六日的最後一天 (10991)

日期：


C2=IF(TEXT(B1,"EM")=TEXT(B2,"EM"),"",EOMONTH(B2,0)-LOOKUP(MOD(EOMONTH(B2,0)-2,7)+1,{1,6,7},{0,1,2}))


D2=IF(C2="","",TEXT(C2,"AAA"))


留言

張貼留言