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

[µo°Ý] ±NÀx¦s®æ¸ê®Æ¦Û°Ê±a¤J¤é¾ä

[µo°Ý] ±NÀx¦s®æ¸ê®Æ¦Û°Ê±a¤J¤é¾ä

¤j®a¦n¡I
·Q½Ð°Ý¦U¦ì±M®a¡A¦³¨S¦³¤è¦¡¯à±NÈЧt¦³¬ÛÃö¤é´ÁªºÀx¦s®æ¸ê®ÆÈЦ۰ʱa¤JÈФé¾äÈÐ

§ÚÁ`¦@¦³¨â­ÓWORKSHEET
²Ä¤@­Ó¬Oªþ¦³¤é´ÁªºÈЭӮײM³æÈСA¦p¤U¹Ï¤@

²Ä¤G­Ó¬O¦Û¤v¼gªºÈФé¾äÈСA¤½¦¡¬O¡@=DAY(DATE($A$1,$B$1,1)-(WEEKDAY(DATE($A$1,$B$1,1),1)-1)+COLUMN(A:A)-1+(ROW(1:1)-1)*7)
¦p¤U¹Ï¤G


·Qª¾¹D¦³¨S¦³¤èªk¡A¥u­n§Ú¦b­Ó®×²M³æ·í¤¤·s¼W¬Y­Ó®×ªº¤é´Á¡A­Ó®×ªº¦W¦r´N·|¦Û°Ê¥X²{¦b¤é¾ä¤¤©O¡H¦p¤U¹Ï¤T

¥H¤W¡AÁÂÁ¤j®aªºÀ°¦£»P«ü±Ð¤F¡I

Â^¨ú.JPG (40.11 KB)

Â^¨ú.JPG

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD