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

¦p¦ó¨ú±o¤W¤W¶g¤é¤Î¤W¶g¤»ªº¤é´Á

¦p¦ó¨ú±o¤W¤W¶g¤é¤Î¤W¶g¤»ªº¤é´Á


¦p¹Ï¤ù,¥H¤µ¤é¬°¨Ò,¥u­n¦b¤j©ó¤W¶g¤»®É¶¡¤UÂI«ö¶s«á
C4¶ñ¤J¤W¤W©P¤é¤é´Á¤Î®É¶¡,D4¶ñ¤J¤W©P¤»¤é´Á¤Î®É¶¡

½Ð°ÝVBA¸Ó¦p¦ó§¹¦¨
Àɮצpªþ¥ó,½Ð¦U¦ì¥ý¶iÀ°À°¦£,¥ýÁÂÁ¤F
book1.rar (5.28 KB)

¦^´_ 1# ycchenzd
[C4] = Date - Weekday(Date) - 6 & " 07:30:00"
[D4] = Date - Weekday(Date) & " 07:30:00"

TOP

¦^´_ 2# GBKEE


    ½Ð°Ýª©¥D
±a¤J¤½¦¡«á..±o¨ìªºµª®×¦n©_©Ç....
½Ð°Ý³]©w­þùؤ£¹ï?
ÁÂÁ±z...

TOP

¦^´_ 3# PD961A
[C4] = Date - Weekday(Date) - 6 & " 07:30:00"
[D4] = Date - Weekday(Date) & " 07:30:00"
³o¬OVBAªºµ{¦¡½X ¤£¬OÀx¦s®æªº¤½¦¡
Àx¦s®æªº¤½¦¡:
=TEXT( TODAY() - WEEKDAY(TODAY()) - 6,"YYY/MM/DD")&"  07:30:00"
=TEXT( TODAY() - WEEKDAY(TODAY()),"YYY/MM/DD")&"  07:30:00"

TOP

¦^´_  ycchenzd
[C4] = Date - Weekday(Date) - 6 & " 07:30:00"
[D4] = Date - Weekday(Date) & " 07:3 ...
GBKEE µoªí©ó 2010-8-6 14:18


·Q¤£¨ì³o»ò²³æ..¯u¬O¤£Â²³æ
¤Ó·PÁ¤F...

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD