function astro(birth) astro="" if birth="" or not isdate(birth) Then exit function birthmonth=month(birth) : if birthmonth10 then birthmonth="0" birthmonth birthday=day(birth) : if birthday10 then birthday="0" birthday birth=trim(birthmonth birthday) '重整月日,0903型 rAstro=split("水瓶座*0120*0219#雙魚座*0220*0320#白羊座*0321*0420#金牛座*0421*0521#雙子座*0522*0621#巨蟹座*0622*0722#獅子座*0723*0823#處女座*0824*0923#天秤座*0924*1023#天蝎座*1024*1122#射手座*1123*1222#摩蝎座*1222*0119#","#") astro="摩蝎座" '這個是跨年的,不好對比,先默認 for i_ls=0 to ubound(rAstro)-2 rls2=split(rAstro(i_ls) "*","*") if birth>=rls2(1) and birth=rls2(2) then astro=rls2(0) exit for end if next end function