日期 星期函数求助答:D2公式:=IF(AND(C2>=A2,C2<=B2,OR(TEXT(C2,"aaa")="一",TEXT(C2,"aaa")="二",TEXT(C2,"aaa")="三")),"AAA","BBB")或 =IF(AND(C2>=A2,C2<=B2,NOT(ISERROR(FIND(TEXT(C2,"aaa"),"一二三"))),"AAA","BBB")E2公式:=IF(AND(C2>=A2,C2<=B2,OR(TEXT(C2,"aaa")...
...提取日期格式中的日数据?并将对应的星期几转换成文本格式?答:假设A1为2010/09/01,提取日公式为:=DAY(A1),显示星期公式为:=IF(A1="","","星期"&CHOOSE(WEEKDAY(A1,2),"一","二","三","四","五","六","日")),希望能帮到你!
JSP将时间转换为星期~在线等~答:写一个方法很简单,java已经实现了:ymd代表年月日 String getWeekDay(int y,int m,int d){ String[] weeks=new String[]{"星期日","星期一","星期二","星期三","星期四","星期五","星期六"};GregorianCalendar gc=new GregorianCalendar();gc.setLenient(false);gc.set(y,m,d);int ...