ªð¦^¦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­Ó
1157531350_o.jpg.png
2018-5-4 00:20



¶]¥hexcel¥Î
µ²ªG¥X²{
6454643123.jpg
2018-5-4 00:18

1221123.jpg
2018-5-4 00:20

¤£ª¾¹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 : ­n§åµû§O¤H®É¡A¥ý·Q·Q¦Û¤v¬O§_§¹¬üµL¯Ê¡C
ªð¦^¦Cªí ¤W¤@¥DÃD