ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¤é´ÁDATE¹Bºâ¿ù»~

[µo°Ý] ¤é´ÁDATE¹Bºâ¿ù»~

·Q½Ð°Ý¦U¦ì¤j¤j¡A§ÚÀɮפºªº²Ä3¦C¦³¨Ï¥ÎDATE­pºâ¤é´Á
¦ý¬O¦b¹w¦ô©ú¦~(108)2¤ë¥÷ªº®É­Ô«o¥X²{¤F29¸¹
½Ð°Ý¬O§_¦³¿ù»~ªº¦a¤è
¦b³Â·ÐÀ°¦£¬Ý¤@¤U¡A·PÁÂ~

¹w©wªí.rar (29.1 KB)

=IF(MONTH(DATE($D$1+1911,$F$1,COLUMN(A1)))<>$F$1,"",DATE($D$1+1911,$F$1,COLUMN(A1)))

¥Á°ê¦~¶·¥[1911
¥k©Ô¥²¶·¨Ï¥Î COLUMN()

TOP

E3:AF3=1~28
AG3:AI3=IF(MONTH(DATE($D1+1911,$F1,$AF3+1))=$F1,$AF3+1,"")
E4:AI4=IF(E3="","",RIGHT(TEXT(DATE($D1+1911,$F1,E3),"AAA")))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¢Ó¢²¡G
=IFERROR(--($D$1+1911&-$F$1&-COLUMN(A1)),"")¡@¡@¥k©Ô

¢Ó¢³¡G
=RIGHT(TEXT($D$1+1911&-$F$1&-COLUMN(A1),"aaa;;;"))¡@¡@¥k©Ô

TOP

¦^´_ 4# ­ã´£³¡ªL
¦^´_ 3# hcm19522
·PÁ ­ã´£³¡ªL ª©¥D ©M hcm19522ªºÀ°¦£

¨âªÌªº¤½¦¡³£¯à¥¿±`¹B¦æ
¥D­n³¡¤Àªº¥Á°ê¦~1911¨S¦³²K¥[©Ò¥H¤~¥X²{­pºâ¿ù»~

¦A¦¸·PÁ¦U¦ì¤j¤jªº¦^ÂÐÀ°¦£

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD