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

[µo°Ý] countif

=MMULT(COUNTIF(I:I,">="&DATE(2014,7+{0,1},1)),{1;-1})
=SUM(COUNTIF(I:I,">="&DATE(2014,7+{0,1},1))*{1,-1})
=SUMPRODUCT(N(TEXT(I1:I60,"yyyymm")="201407"))
½d³ò¤¤§t[ªÅ¥Õ.0­È."",¤å¦r], ¬Ò¥i¥¿±`­pºâ!

¤@¯ë¨Ï¥Î MONTH(A1:A3) ©Î TEXT(A1:A3,"M") ®É, ªÅ®æ©Î0­È³£³Qºâ¦b[1¤ë]¥÷¤¤,¥i´ú¸Õ¬Ý¬Ý~~

TOP

        ÀR«ä¦Û¦b : ¯à·F¤£·F¡A¤£¦p­W·F¹ê·F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD