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

[µo°Ý] ¦p¦ó§PÂ_¤é´Á¦b1¸¹~5¸¹¤§¶¡? (ªÑ²¼¶}½L¤é,«D¤@¯ë¤é´Á)

[µo°Ý] ¦p¦ó§PÂ_¤é´Á¦b1¸¹~5¸¹¤§¶¡? (ªÑ²¼¶}½L¤é,«D¤@¯ë¤é´Á)

¦pªG1¸¹¨ì5¸¹³£¦³¶}½Lªº¸Ü!
1¸¹~5¸¹ ,·|¦³5¤Ñ²Å¦X±ø¥ó.
¦b¤£¨Ï¥ÎVBA¤U,¦p¦ó¥uÅã¥Ü²Ä¤@­Ó²Å¦X±ø¥óªº¤é´Á?
·PÁÂ...
test.rar (7.11 KB)

=IF((DAY(A2)=1)*(DAY(A6)=5),"²Å¦X","")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# hcm19522


hcm19522 ·PÁ§Aªº¦^ÂÐ...
¤£¦n·N«ä,§Ú»¡ªº¤£°÷²M·¡...
¦pªGªÑ¥«¤é´Á¦b1¸¹¨ì5¸¹¤§¶¡ªº¸Ü,³o5¤Ñ³£·|²Å¦X§Úªº±ø¥ó(2/1, 2/2, 2/3, 2/4, 2/5)
,¦ý§Ú¥u­n²Ä¤@­Ó1¸¹Åã¥Ü´N¦n.
°ÝÃD¨Ó¤F,¦pªG3/1¨S¶}½L. ¥u¦³3/2, 3/3, 3/4, 3/5 ²Å¦X±ø¥óªÑ¥«¤é´Á¦b1¸¹¨ì5¸¹¤§¶¡.
¨º²Ä¤@­Ó²Å¦X±ø¥óªº«h·|¬O3/2.
=IF((DAY(A2)=1)*(DAY(A6)=5),"²Å¦X","")  => ¥u¯àÅã¥Ü1¸¹
http://blog.xuite.net/hcm19522/twblog/563708697 => excel2003³£Åã¥ÜªÅ¥Õ  >.<

ÁÙ½Ðhcm19522 À°¦£«üÂI
·PÁ¤j®a¶i¨Ó.

TOP

¦^´_ 4# newsoft
  1. =IF(AND(ISERROR(WEEKNUM(A1)),WEEKDAY(A2,2)<6),"²Å©M",IF(WEEKNUM(A1)<>WEEKNUM(A2),"²Å©M",""))
½Æ»s¥N½X
B2¤½¦¡¤U©Ô
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 1# newsoft


    ¾A¥Î±¡ªp¡A¤é´Á»¼¼W±Æ§Ç¡A¤½¦¡¸Ô¸Ñ¡A½Ð°Ñ¦Ò¡Ghttps://goo.gl/mj4Y41
E0193_1.png
2018-2-7 11:47

TOP

¦^´_ 4# newsoft


    ¦ü¥G¬O§ä¨ì·í¤ë²Ä¤@­Ó¤u§@¤éªº·N«ä
=IF(WORKDAY(EOMONTH(A2,-1),1)=A2,"²Å¦X","")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 5# GBKEE

joblyc017¤j¤ÎHsieh¤j ³£¯à¥¿±`Åã¥Ü...

GBKEE¤jªº¤èªk¬OÅã¥Ü¨C¬P´Á²Ä¤@­Ó¥æ©ö¤é.
§ï¦¨³Ì¤U­±¥i¥H¥¿±`Åã¥Ü¤ëªì²Ä¤@­Ó¥æ©ö¤é.
¦pªG­n¨ú¤ë¤¤(13¸¹~17¸¹)ªº²Ä¤@­Ó¥æ©ö¤é,¸Ó¦p¦ó­×§ï¤ñ¸û¦n?
§Úª½±µ§ó§ïHsieh¤jªº¤½¦¡ =IF(WORKDAY(EOMONTH(A2,-1),11)=A2,"²Å¦X","")
ª½±µ+11¤Ñ,¦ý¨C¤ë¤Ñ¼Æ¤£¦P,©Ò¥H¤£¯à¥¿±`Åã¥Ü.
·Ð½Ð¦U¦ìÀ°¦£«üÂI,·P¿E¤£ºÉ.


=IF(AND(ISERROR(MONTH(A1)),DAY(A2)<6),"²Å¦X",IF(MONTH(A1)<>MONTH(A2),"²Å¦X",""))

TOP

¦^´_ 8# newsoft
EOMONTH(A2,-1)¨ú±o«e¤@­Ó¤ëªº³Ì«á¤@¤Ñ
­Y­n¨ú¤ë¤¤¤é´Á¡A¥H§A¤§Á|¨Ò13¤é¬°¶}©l§PÂ_¤é´Á
EOMONTH(A2,-1)+12´N¯à¨ú±o·í¤ëªº12¤é
12¤é¤§«áªº²Ä¤@¤u§@¤é´N¬O§A­nªº¤é´Á
=WORKDAY(EOMONTH(A2,-1)+12,1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 9# Hsieh

·PÁÂHsieh¤j¤Î¨ä¥L°ª¤âÀ°¦£
¥i¥H¥¿±`Åã¥Ü¤F :D

TOP

        ÀR«ä¦Û¦b : µoµÊ®ð¬Oµu¼ÈªºµoºÆ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD