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

[µo°Ý] ¦p¦ó¦Û°ÊÅã¥Ü³Ì«á¤@¤Ñ¬I¤u¤é´Á

[µo°Ý] ¦p¦ó¦Û°ÊÅã¥Ü³Ì«á¤@¤Ñ¬I¤u¤é´Á

¦Û°ÊÅã¥Ü³Ì«á¤@¤Ñ¬I¤u¤é´Á
½Ð°Ý¦U¦ì¤j­ô¦p¦ó³]©w?
¦pªþ¥ó©Ò¥Ü....ÁÂÁÂ

¥X²{³Ì«á¤@¤Ñ.zip (406.36 KB)

¦^´_ 1# jeff5424

¸Õ¸Õ¬Ý
   E4Àx¦s®æ
=IF(E3="","",IF(EOMONTH(DATE(A3,C3,E3),0)>=DATE(A3,C3,E3)+7,E3+7,""))
½Æ»s¤½¦¡¦V¤U

  E10Àx¦s®æ
=DATE(A3,C3,MAX(E3:E7))

¥X²{³Ì«á¤@¤Ñ0305.zip (402.46 KB)

TOP

E4:E7=IF(E3="","",REPT(E3+7,1-ISERR(-(A$3&-C$3&-(E3+7)))))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

·PÁÂcucu¤Îhcm19522¤j¤j
¸g´ú¸Õ¥i¥¿±`¨Ï¥Î

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD