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

[µo°Ý] ·Q½Ð°Ý¤@¤U ¥X²{value ¼Æ­È¥X¤£¨Ó

[µo°Ý] ·Q½Ð°Ý¤@¤U ¥X²{value ¼Æ­È¥X¤£¨Ó

«e´X¤Ñ¦³¨Óª©¤Wµo°Ý¦p¦ó¥Í¦¨ ¹³google¤é¾äªºªí®æ

µ²ªG¦³¼ö¤ßªº¤j¤j´£¨Ñ¤½¦¡«á
³o­Ó
E2:K12=DAY(DATE($A$2,$B$2,1)-WEEKDAY(DATE($A$2,$B$2,1),1)+COLUMN(A1)+INT((ROW(A1)-1)/2)*7)
¦¨¥\ªº¸Ü
·|Åܦ¨³o­Ó



¶]¥hexcel¥Î
µ²ªG¥X²{


¤£ª¾¹D¬O­þ¸Ì¥X²{°ÝÃD

²q·Q, «e½úªº·N«ä¬O§i¶D±zcell name  ±qE2 ¨ì: K2ªº, ½Ð±zcopy ³o­Ó¤½¦¡ =DAY(DATE($A$2,$B$2,1)-WEEKDAY(DATE($A$2,$B$2,1),1)+COLUMN(A1)+INT((ROW(A1)-1)/2)*7)
±z§â= E2:K2 ®³±¼´N¹ï¤F.

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD