¤ë¥÷¦æ¨Æ¾äÅã¥Ü

shan0948

¦U¦ì¥ý¶i¦n¡A¤p§Ì¦³¦æ¨Æ¾äÅã¥Üªº¨ç¼Æ¤½¦¡³]©w°ÝÃD­n³Â·Ð¨ó§U¡A¸Ô²Ó½Ð°Ñ¦Òªþ¥ó¤ºªº»¡©ú¡AÁÂÁ¡I ¤ë¥÷¦æ¨Æ¾ä.zip (38.29 KB)

¤U¸ü¦¸¼Æ: 5

2020-5-20 19:17

shan0948

¦^´_ 9# ­ã´£³¡ªL


    ±z¦n¡A·PÁ±zªº¨ó§U«ü¾É¥t¤@ºØ¼gªk¡I

shan0948

¦^´_ 8# ­ã´£³¡ªL

±z¦n¡A·PÁ±zªº¨ó§U«ü¾É¡A³o¤½¦¡¸g´ú¸Õ¤]¥i¥HÅã¥Ü©Ò­n¤é´Á¡A³o¤½¦¡ªº¼gªk²Ä¤@¦¸¬Ý¨ì¡Aªøª¾ÃѤF¡AÁÂÁ±z¡I

­ã´£³¡ªL

°}¦C¤½¦¡:
=iferror(VLOOKUP($B$2&"¶g"&RIGHT(E$1),TEXT(DATE($A$2+1911,$B$2,1-ROW($1:$7))+ROW(A3)/3*7-7+COLUMN(A1),{"maaa","d"}),2,),"")

©Î/±N²Ä¤@¦æªº"©P"§ï¦¨"¶g":
=iferror(VLOOKUP($B$2&E$1,TEXT(DATE($A$2+1911,$B$2,1-ROW($1:$7))+ROW(A3)/3*7-7+COLUMN(A1),{"maaa","d"}),2,),"")

­ã´£³¡ªL

=iferror(--VLOOKUP($B$2&"",TEXT(SUM(MOD(DATE($A$2+1911,$B$2,),{7,"1e9"})*{-1,1})+ROW(A3)/3*7-7+COLUMN(A1),{"m","d"}),2,),"")

shan0948

¦^´_ 6# hcm19522

±z¦n¡A·PÁ±zªº¨ó§U«ü¾É¡A³o¤½¦¡¸g´ú¸Õ¥¿¬O»Ý­nªº±¡ªp¡AÁÂÁ±z¡I

hcm19522

¦^´_ 5# shan0948


    E2=IF(MONTH(DATE($A$2,$B$2,1)-WEEKDAY(DATE($A$2,$B$2,1),1)+COLUMN(A1)+INT((ROW(A1)-1)/2)*7)=$B$2,DAY(DATE($A$2,$B$2,1)-WEEKDAY(DATE($A$2,$B$2,1),1)+COLUMN(A1)+INT((ROW(A1)-1)/2)*7),"")

shan0948

¦^´_ 3# hcm19522


    ±z¦n¡A·PÁ±zªº¨ó§U«ü¾É¡A³oºØ¤è¦¡¥i¥H¨Ï¥Î¡A½Ð°Ý¦³µLª½±µ¨Ï¥Î¤½¦¡¨ç¼Æ¨Ó¹F¨ì«D¥»¤ë¥÷¤£Åã¥Ü¤é´Áªº±¡ªp¡A¤]´N¬O¥uÅã¥Ü¥»¤ë¥÷ªº¤é´Á¡AÁÂÁ¡I

shan0948

¦^´_ 2# luhpro

±z¦n¡A·PÁ±zªº¨ó§U«ü¾É¡A³oºØ¤è¦¡¥i¥H¨Ï¥Î¡A½Ð°Ý°£¤F®æ¦¡³]©w¤è¦¡¥~¡A¦³µLª½±µ¨Ï¥Î¤½¦¡¨ç¼Æ¨Ó¹F¨ì¥Øªº¡AÁÂÁ¡I

hcm19522

https://blog.xuite.net/hcm19522/twblog/495541260