¤ë¥÷¤é´Á§ïÅÜ

ws2315

½Ð¦U¦ì¤j¤j«ü¾É¤ë¥÷¤é´Á§ïÅÜ,·P謉

ws2315

¥´¿ù,¬O·PÁÂ

hcm19522

E2=IF(MONTH(DATE($N1+1911,$P1,COLUMN(A1)))=$P1,TEXT(DATE($N1+1911,$P1,COLUMN(A1)),"M/D"),"")
E3=IF(E2="","",RIGHT(TEXT(E2,"AAA")))

ws2315

¦^´_ 3# hcm19522

1. 3¤ëE4~E6¥þ³¡Åܦ¨¥ð.E7~E9¥þ³¡Åܦ¨¤j.E10~E12¥þ³¡Åܦ¨¦­.E13~E15¥þ³¡Åܦ¨¥ð
2. ¿é¤J¥ô¦ó¦~¨Ò¦p110~130 3¤ë¬P´Á©T©w¤£ÅÜ
3. 117,2.29¬P´ÁÅܦ¨9  .AG4~AG18Åܦ¨####

    ½Ð¤j¤j¦A«ü¾É,·PÁÂ

hcm19522

¦^´_ 4# ws2315

E2 (©w¸q M/D)=IF(MONTH(DATE($N1+1911,$P1,COLUMN(A1)))=$P1,DATE($N1+1911,$P1,COLUMN(A1)),"")

ws2315

¦^´_ 5# hcm19522


·PÁ¤j¤j
3¤ëE4~E6¥þ³¡Åܦ¨¥ð.E7~E9¥þ³¡Åܦ¨¤j.E10~E12¥þ³¡Åܦ¨¦­.E13~E15¥þ³¡Åܦ¨¥ð
½Ð¤j¤j¦A«ü¾É

hcm19522

¦^´_ 6# ws2315

°Ñ¦Ò(·j´M ¿é¤J¸¹½X 14886) googleºô§}:https://hcm19522.blogspot.com/

ws2315

·PÁÂf¤j,¦A¸Õ¸Õ

ws2315

¦^´_ 7# hcm19522 ½Ð¤j¤j¦A«ü¾É,·PÁÂ


    test01.rar (8.17 KB)

¤U¸ü¦¸¼Æ: 3

2026-3-3 20:21

ws2315

·PÁ¦U¤j¤j,¤w¸Ñ¨M