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

shan0948

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

¤U¸ü¦¸¼Æ: 5

2020-5-20 19:17

luhpro

¦U¦ì¥ý¶i¦n¡A¤p§Ì¦³¦æ¨Æ¾äÅã¥Üªº¨ç¼Æ¤½¦¡³]©w°ÝÃD­n³Â·Ð¨ó§U¡A¸Ô²Ó½Ð°Ñ¦Òªþ¥ó¤ºªº»¡©ú¡AÁÂÁ¡I
shan0948 µoªí©ó 2020-5-20 19:18

²Ä¤@­Ó°ÝÃD«Ü²³æ,
¥u­n§ä¤@­Ó¨S¥Î¨ìªºÀx¦s®æ(¨Ò¦p: A3)¦s©ñ°ê¾äÂà¦è¾äªº¤½¦¡(=A2+1911),(¤å¦rÃC¦â«h³]©w¥Õ¦â=¤£Åã¥Ü)
¨ä¥LÀx¦s®æ¤½¦¡ªº°Ñ·Ó±qA2§ï¦¨¸ÓÀx¦s®æ¦ì§}(A3)§Y¥i.

¦Ü©ó²Ä¤G­Ó°ÝÃD¤]¤£Ãø,
§Q¥Î±ø¥ó¦¡®æ¦¡³]©w¥\¯à,
°w¹ï²Ä¤@¶g¤j©ó7»P¥½¨â¶g¤p©ó15ªº,
³]©w¤å¦rÃC¦â¬O¥Õ¦â(=¤£Åã¥Ü)§Y¥i

¤ë¥÷¦æ¨Æ¾ä-Ans.zip (39.58 KB)

¤U¸ü¦¸¼Æ: 13

2020-5-20 23:40

¤U¸ü (102.35 KB)

2020-5-20 23:40

hcm19522

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

shan0948

¦^´_ 2# luhpro

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

shan0948

¦^´_ 3# hcm19522


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

¦^´_ 6# hcm19522

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

­ã´£³¡ª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,),"")

­ã´£³¡ª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,),"")

shan0948

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

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