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

©P¤»¤éÅã¥ÜÃC¦â

©P¤»¤éÅã¥ÜÃC¦â

½Ð°Ý¦U¦ì¥ý¶i¡A¤WªíªºÀx¦s®æ¦³¤é´Á¤Î¬P´Á¦P®ÉÅã¥Ü¡A¤µ¤Ñ­n¦p¦ó³]©w®æ¦¡¤Æ±ø¥ó¡A±N©P¤»©M©P¤éªºÀx¦s®æÅã¥ÜÃC¦â¡A¸Õ¤F¦h¦¸¤´µLªk¦¨¥\¡A½Ð¥ý¶i«ü±Ð¡AÁÂÁ¡I ©P¤»¤éÅã¥ÜÃC¦â.zip (8.71 KB)

©ó®æ¦¡¤Æ±ø¥ó¥Î
=IF(AND(ISERROR(SEARCH("¤»",L1)),ISERROR(SEARCH("¤é",L1))),FALSE,TRUE)
·í±ø¥ó§PÂ_¶g¤»¤é«á¨M©w¨q¥XÃC¦â
ù

TOP

¿ï G1:AK1
³]©w®æ¦¡¤Æ±ø¥ó
¦Û­q¤½¦¡
=OR(RIGHT(G1)="¤»",RIGHT(G1)="¤é")
¶ñº¡ÃC¦â ....
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¤é´Á¥uÅã¥Ü·í¤ë¥÷:
G1:
=TEXT($B1&-$B2&-COLUMN(A1),"d aaa;;;")

®æ¦¡±ø¥ó:¤»/¤é¶ñ¦â:
=FIND(RIGHT(G$1),"_¤»¤é")>1

TOP

«Øij±NG1§ï¬°¹ê»Ú¤é´Á®æ¦¡

G1 =IF(MONTH(DATE($B$1,$B2,COLUMN(A1)))=$B2,DATE($B$1,$B2,COLUMN(A1)),"")
¥kÁä - Àx¦s®æ®æ¦¡ - ¼Æ­È - ¦Û­q  "d aaa"


³]©w®æ¦¡±ø¥ó:¤»/¤é¶ñ¦â:
=WEEKDAY(G1,2)>5
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# rouber590324


    ·PÁ rouber590324 «ü¾É¡A¸g´ú¸Õ«á²Å¦X»Ý­n¡AÁÂÁ¡I

TOP

¦^´_ 3# ML089


    ·PÁ ML089 ªº¤G­Ó³]©w¤è¦¡¡A´ú¸Õ«á³£²Å¦X»Ý­n¡A¤×¨ä²Ä¤@­Ó¤è¦¡«Ü²³æ¡AÁÂÁ¡I

TOP

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


    ·PÁ­ã¤jªº«ü¾É¡A¤½¦¡Â²¶¡¡A¸g´ú¸Õ«á²Å¦X»Ý­n¡AÁÂÁ¡I

TOP

=MOD($B3+COLUMN(A1)-3,7)>4
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 9# hcm19522


    ·PÁ hcm19522 ªº«ü¾É¡A¤½¦¡¤]«Ü²³æ²Å¦X»Ý­n¡AÁÂÁ¡I

TOP

        ÀR«ä¦Û¦b : ¯àµ½¥Î®É¶¡ªº¤H¡A¥²¯à´x´¤¦Û¤v§V¤Oªº¤è¦V¡C
ªð¦^¦Cªí ¤W¤@¥DÃD