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

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

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

TOP

«ØÄ³±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

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD