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

[µo°Ý] ¤é´Á¤ñ»å¿ù»~??

[µo°Ý] ¤é´Á¤ñ»å¿ù»~??

6/3 ¤ñ6/4 ¤j????? Book2.rar (56.12 KB)

§Ú²q¦pªG§Ú¤£¦^À³¸Ó¨S¤H·Q¦^ ®Ú¥»³s°Ý°ÝÃD³£¤£·|
6/4·íµM¤ñ6/3¸¹¤j
§AÀɮ׸̭±®Ú¥»¨S¦³¥ô¦ó³]©w °ß¿W¦³¤@Äæ¬O¶À¦â©³¦â ¸Ì­±¤]¨S¦³®æ¦¡¤Æ±ø¥ó

TOP

¦^´_ 1# t8899

®æ¦¡½Ð¥ý§Ë¥¿½T¡A¤~¨Ó¤ñ¤j¤p
6/3=2 > 6/4=1.5 ¦X²zªü:lol

¦Û¤v¸Õ:
=IF(6/3>6/4,TRUE,FALSE)
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

Columns("J:J").Select
Selection.NumberFormatLocal = "yyyy/m/d;@"
If CDate(Left(Cells(k, "J"), 3) + 1911 & Mid(Cells(k, "J"), 4, 6)) < Date Then

TOP

d = DateValue("r" & [J20])  '¥Á°ê¦~Âà¦è¤¸
MsgBox d

TOP

        ÀR«ä¦Û¦b : §Ú­Ì³Ì¤jªº¼Ä¤H¤£¬O§O¤H¡D¥i¯à¬O¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD