·Qn½Ð°Ý,§Ú·Q¼g¤@Ó§PÂ_¦¡¡A§PÂ_¤@Ó¤é´Á¬O§_¦b¤@Ó½d³ò¤§¤º¡A³oÀ³n¦p¦ó¼g¡H
¨Ò¦p¡A§Ú·Qn§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Âù¤Þ¸¹ªº¶Ü?
:) |