ªð¦^¦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)))))
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

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

TOP

        ÀR«ä¦Û¦b : ­ì½Ì§O¤H´N¬Oµ½«Ý¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD