I3=IFERROR(TEXT(YEAR(NOW())&"-"&LOOKUP(1,0/FIND(TEXT(ROW($1:$12),"[DBNUM1]D月"),G3),ROW($1:$12))&"-"&LOOKUP(1,0/FIND(TEXT(ROW($1:$31),"[DBNUM1]D日"),G3),ROW($1:$31)),"YYY年M月D日")*1,G3)
J3=IFERROR(LOOKUP(1,-FIND(TEXT(ROW($1:$12),"[DBNUM1]d月"),G3),ROW($1:$12)),MONTH(G3))
留言
張貼留言