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

[µo°Ý] Ãö©ó¶g¼ÆÂà¤é´Á°Ï¶¡¸ß°Ý

[µo°Ý] Ãö©ó¶g¼ÆÂà¤é´Á°Ï¶¡¸ß°Ý

¤j¤j­Ì±ß¤W¦n:
³Ìªñ§Ú¹J¨ì¤@­Ó°ÝÃD
EXCEL¥i¥Hµ¹¥L¤@­Ó¤é´Á~¥i¥H§Q¥Î¨ç¼Æºâ¥X¸Ó¤é´Á¸¨©ó¸Ó¦~¥÷ªº­þ­Ó¶g¼Æ¤W
¦ý³Ìªñ§Ú»Ý­n¿é¤J¬Y¦~¥÷»P²Ä´X¶g¨Ó¨D¥X¸Ó¤é´Áªº°Ï¶¡~~~
¤£ª¾¥i¥H«ç»ò¸Ñ©O???
§Ú¥Ø«e¥u·Q¨ì§ì¥X¨C¦~ªº1/1¬°²Ä¤@¶gªº¬P´Á´X~~~
µM«á~~~~´N¥dÃö¤F
Àµ½Ð¤j¤j­ÌÀ°¦£~~~~ÁÂÁ¤j¤j

test.PNG (6.29 KB)

test.PNG

TEST.rar (6.15 KB)

²Ä¤@¶g¤Ñ¼Æ  8-WEEKDAY(DATE(A2,1,1))
²Ä¤G©P«á¤Ñ¼Æ  °_ (B2-2)*7 + 1¡A¨´ (B2-1)*7

°_
=MAX(DATE(A2,1,0) + 8-WEEKDAY(DATE(A2,1,1)) + (B2-2)*7 + 1, DATE(A2,1,1))
°W
=MIN(DATE(A2,1,0) + 8-WEEKDAY(DATE(A2,1,1)) + (B2-1)*7, DATE(A2,12,31))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

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

TOP

¦^´_ 2# ML089

¤Q¤À·P¿EML089ª©¤jªºÀ°¦£....

®¦~¤½¦¡ªººâªk¤j­P¤WÀ´~~
¦ý§Ú·Q½Ð°Ý¤@¤U¦p¦ó±oª¾²Ä¤G¶g«áªº¤Ñ¼Æªººâªk¬O (B2-2)*7 + 1©O????³o³¡¤Àªº·N«ä¬O????
Àµ½ÐML089ª©¤j¦A«üÂI¤@¤G....ÁÂÁª©¤j......

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2017-9-30 17:11 ½s¿è

¨C©P¤Ñ¼Æ 7 ¤Ñ
²Ä2©Pªº²Ä¤@¤Ñ¡A¬O²Ä1©P¤Ñ¼Æ + 1 + 00¡A
²Ä3©Pªº²Ä¤@¤Ñ¡A¬O²Ä1©P¤Ñ¼Æ + 1 + 07¡A
²Ä4©Pªº²Ä¤@¤Ñ¡A¬O²Ä1©P¤Ñ¼Æ + 1 + 14¡A
²Än©Pªº²Ä¤@¤Ñ¡A¬O²Ä1©P¤Ñ¼Æ + 1 + (n-2)*7¡A

²Ä2©Pªº³Ì«á¤@¤Ñ¡A¬O²Ä1©P¤Ñ¼Æ + 7 + 00¡A
²Ä3©Pªº³Ì«á¤@¤Ñ¡A¬O²Ä1©P¤Ñ¼Æ + 7 + 07¡A
²Ä4©Pªº³Ì«á¤@¤Ñ¡A¬O²Ä1©P¤Ñ¼Æ + 7 + 14¡A
²Än©Pªº³Ì«á¤@¤Ñ¡A¬O²Ä1©P¤Ñ¼Æ + 7 + (n-2)*7¡A

³oºâ¬O¼Æ¾ÇÂk¯Çªkªº¤èªk
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# ML089
­ì¨Ó¦p¦¹~~~~~
ÁÂÁÂML089¤j¤jªº«ü¾É~~~~

(»°ºòµ§°O°µ°_¨Ó.....)

«D±`·P¿E.....

TOP

        ÀR«ä¦Û¦b : ¨ü¤HÂI¤ô¤§®¦¡A¶··í´é¬u¥H³ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD