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

[µo°Ý] §Ú·Q­n½Ð°Ý¦p¦ó§PÂ_Àx¦s®æªº¤é´Á¬O§_¤¶©ó¨â­Ó¤é´Á¤§¶¡

[µo°Ý] §Ú·Q­n½Ð°Ý¦p¦ó§PÂ_Àx¦s®æªº¤é´Á¬O§_¤¶©ó¨â­Ó¤é´Á¤§¶¡

·Q­n½Ð°Ý,§Ú·Q¼g¤@­Ó§PÂ_¦¡¡A§PÂ_¤@­Ó¤é´Á¬O§_¦b¤@­Ó½d³ò¤§¤º¡A³oÀ³­n¦p¦ó¼g¡H
¨Ò¦p¡A§Ú·Q­n§PÂ_A1ªº­È¬O§_¤¶©ó2014¦~10¤ë01¤é¨ì12¤ë31¤é¤§¶¡¡C

ÁÙ¦³..
¬°¦ó§Ú¦bA1¿é¤J2014/11/14¡A
      ¦bA2¿é¤J2104/11/15®É¡A
§Ú¦bB2¿é¤J =IF(A2>A1,"¤j","¤p") ®É,©Ò±o¨ìªº­È¬O¡¨¤j¡¨
¦Ó­Y±N³o¤½¦¡¤¤ªºA1§ï¬°¤é´Á¡AÅܦ¨=IF(A2>"2014/11/14","¤j","¤p")¡A©Ò±o¨ì­È«o¬O¡¨¤p¡¨©O?
³o¤é´Á¦b¤½¦¡¤¤ªº¼gªk¤£¬O¥[¤WÂù¤Þ¸¹ªº¶Ü?
:)
¶³®p

¥»©«³Ì«á¥Ñ p212 ©ó 2014-11-17 16:36 ½s¿è

¦^´_ 1# blueskyneter
Q1: §PÂ_¤@­Ó¤é´Á¬O§_¦b¤@­Ó½d³ò¤§¤º
=IF((A1>=DATEVALUE("2014/10/01"))*(A1<=DATEVALUE("2014/12/31")),"Yes","No")
¤W¦C¡u*¡v¥Nªí¡uAND¡v¤§·N
Q2:
1#¤§=IF(A2>"2014/11/14","¤j","¤p")
­×§ï¬°
=IF(A2>DATEVALUE("2014/11/14"),"¤j","¤p")
½Ð°Ñ¦Ò¡I

TOP

ÁÂÁ±zªº¦^ÂÐ,§Ú¨Ó¸Õ¬Ý¬Ý,µ¥µ¥¦A¤W¨Ó½Ð±Ð¡C
¢â¢Ù¢á

TOP

¦n¤F¡D¡D¤Ó¦n¤F¡I
·PÁÂp212§Aªº¦^ÂСD
¯uªº¤£ª¾¹D­ì¨ÓIFÁÙ¦³³o¼Ëªº¥Îªk¡A§Ú¸Õ¤F«Ü¦hªº¤èªk¡A³£¨S¦³·Q¹L¦³³o¼Ëªº¨Ï¥Î¤èªk¡C
¦A¦¸·PÁÂ!

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD