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

[µo°Ý] ½Ð°Ý EXCEL ¦~°²­pºâ

[µo°Ý] ½Ð°Ý EXCEL ¦~°²­pºâ

½Ð°Ý¦U¦ì°ª¤â¦p¦ó¥HEXCEL­pºâ¦~°²
§Ú­n­pºâ¤è¦¡¦p¤U
¶i¤½¥qº¡¤@¦~¥H¤W¤T¦~¥¼º¡ªÌ¤C¤Ñ
º¡¤T¦~¥H¤W¥¼º¡¤­¦~ªÌ¤Q¤Ñ
º¡¤­¦~¥H¤W¥¼º¡¤Q¦~ªÌ¤Q¥|¤Ñ
º¡¤Q¦~¥H¤WªÌ¡A¨Cº¡¤@¦~¥[µ¹¤@¤Ñ¡A¥[¦Ü¤T¤Q¤é¬°¤î
¥¼º¡¤@¦~ªÌ¨Ì¤ñ¨Ò­ì«h­p
¥¼¨¬¤ëªÌ¥H¨C¤ë¤Q¤­¤é­p¡A¤Q¤­¤é¡]§t¡^¤§«e¨ì¾µø¬°¥þ¤ë¡A¤Q¤»¤é¡]§t¡^«á¨ì¾µø¬°¦¸¤ë¡C

¬Y¤H¨ì¾¤é¡G100/4/17
101/4/17´Nº¡1¦~¤F.
¦ý¦]¬°¤½¥q³W©w[¥¼¨¬¤ëªÌ¥H¨C¤ë¤Q¤­¤é­p¡A¤Q¤­¤é¡]§t¡^¤§«e¨ì¾µø¬°¥þ¤ë¡A¤Q¤»¤é¡]§t¡^«á¨ì¾µø¬°¦¸¤ë¡C]
©Ò¥H¦¹¤H4/17¨ì¾µø¬°¦¸¤ë³o¼ËEXCEL¤½¦¡¸Ó¦p¦ó³]©w?
MIKI589

http://forum.twbts.com/viewthrea ... hlight=%A6%7E%B0%B2
¥¼¨¬¤ëªÌ¥H¨C¤ë¤Q¤­¤é­p¡A¤Q¤­¤é¡]§t¡^¤§«e¨ì¾µø¬°¥þ¤ë¡A¤Q¤»¤é¡]§t¡^«á¨ì¾µø¬°¦¸¤ë¡C
=IF(DAY(A2)<=15,A2-DAY(A2),EDATE(A2,1)-DAY(A2))

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD