【练习题003】根据指定日期返回所在日期天数

楼主天南地北	要求：A2为随机指定日期（格式为年-月-日的可识别的标准日期格式），要求计算A2所在月份的天数，用公式计算，每1个正确公式1个魅力值，公式不限版本，直接跟帖贴上公式即可！答题截至：2014年1月15日 PS:大家发挥发散思维，看看到底能想出多少方法！
2楼嘉昆2011	2007 or higher version: =DAY(EOMONTH(A2,0)) 2003 version: =DAY(DATE(YEAR(A2),MONTH(A2)+1,0))
3楼 hustclm	=DAY(DATE(YEAR(A2),MONTH(A2)+1,1)-1)
4楼 windimi007	=DAY(EDATE(A2,1)-DAY(A2)) =LOOKUP(32,DAY(TEXT(A2,"e-m-")&ROW(1:31)))
5楼 rongjun	=EOMONTH(A2,0)-EOMONTH(A2,-1)
6楼 windimi007	=MAX(DAY(A2+ROW(1:30)))
7楼 windimi007	=DAY((TEXT(EDATE(A2,1),"e-m-")&1)-1)
8楼懃奋学习	=DAY(EOMONTH(A2,0)) =day(date(year(a2),month(a2)+1,0))
9楼 wjc2090742	=COUNT(-(TEXT(A2,"e-m")&-ROW(1:31))) =DAY(EOMONTH(A2,0)) =DAY(DATE(YEAR(A2),MONTH(A2)+1,0)) =DAY((YEAR(A2)&-MONTH(A2)-1&-1)-1) =DAY(EDATE(A2-DAY(A2),1)) =SUM(N(MONTH(A2+ROW(1:62)-31)=MONTH(A2)))
10楼健康快乐123	1、=DAY(EDATE(TODAY(),1)-DAY(TODAY())) 2、=DAY(EOMONTH(TODAY(),0)) 3、=DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,))
11楼亡者天下	=DAY(EOMONTH(A2,0)) =DAY(DATE(YEAR(A2),MONTH(A2)+1,0))
12楼水星钓鱼	刚回到福州，先答1个，明天继续 =DAY(EOMONTH(A1,0))
13楼嘉昆2011	=EDATE(A2,1)-A2 =DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-1) 以下两个是改编的， =LOOKUP(32,DAY(YEAR(A2)&-MONTH(A2)&-ROW($28:$31))) 数组： =MATCH(,-(YEAR(A2)&-MONTH(A2)&-ROW($1:$31)))
14楼 windimi007	=DATE(YEAR(A2),MONTH(A2)+1,DAY(A2))-A2
15楼 wise	请查看： =DAY(EOMONTH(A2,0)) =DAY(DATE(YEAR(A2),MONTH(A2)+1,))
16楼 kirstenzyl	=DAY(DATE(YEAR(A2),MONTH(A2)+1,0))
17楼 CheryBTL	凑几个： =DATE(YEAR(A2),MONTH(A2)+1,DAY(A2))-A2 =DAY(DATE(YEAR(A2),MONTH(A2)+1,)) =DAY(EDATE(TEXT(A2,"e-m")&-1,1)-1) =DAY(EOMONTH(A2,0)) =COUNT(-(TEXT(A2,"e-m")&-ROW(1:31))) =DATEDIF(DATE(YEAR(A2),MONTH(A2),),DATE(YEAR(A2),MONTH(A2)+1,),"d")</p> =EDATE(A2,1)-A2 有问题，更新下
18楼海洋之星	初学者水平，还不知道对不 =DAY(DATE(YEAR(A4),MONTH(A4)+1,0))
19楼 Ex_Study	我是使用了三个公式：具体的可以看附件1、=CHOOSE(IF(OR(AND(MOD(YEAR(A2),4)=0,MOD(YEAR(A2),100)),MOD(YEAR(A2),400)=0),2,1),CHOOSE(MONTH(A2),31,28,31,30,31,30,31,31,30,31,30,31),CHOOSE(MONTH(A2),31,29,31,30,31,30,31,31,30,31,30,31)) 2、=IF(OR(AND(MOD(YEAR(A2),4)=0,MOD(YEAR(A2),100)),MOD(YEAR(A2),400)=0),VLOOKUP(MONTH(A2),{1,31;2,29;3,31;4,30;5,31;6,30;7,31;8,31;9,30;10,31;11,30;12,31},2,FALSE),VLOOKUP(MONTH(A2),{1,31;2,28;3,31;4,30;5,31;6,30;7,31;8,31;9,30;10,31;11,30;12,31},2,FALSE)) 3、=CHOOSE(MONTH(A2),31,IF(OR(AND(MOD(YEAR(A2),4)=0,MOD(YEAR(A2),100)),MOD(YEAR(A2),400)=0),29,28),31,30,31,30,31,31,30,31,30,31) 日期获取天数(Ex_Study).rar
20楼 Ex_Study	如何设置仅作者可见
21楼 cloudmountai	=DAY(DATE(YEAR(A2),MONTH(A2)+1,0))
22楼 autumn87	=DAY(DATE(YEAR(A2),MONTH(A2)+1,))
23楼 windimi007	=MAX(IF(MONTH(A2+ROW(1:30))=MONTH(A2),DAY(A2+ROW(1:30))))
24楼 muxi	=DAY(EOMONTH(A2,MONTH(A2))) 知道这个不对，2月份的特别是闰年的二月份都不知怎么办~~ 菜鸟级别的只能做到此了~~ 静等答案了~~~
25楼水星钓鱼	=DAY(DATE(YEAR(A2),MONTH(A2)+1,))
26楼水星钓鱼	公式错了
27楼 HIMYM	=DAY(EOMONTH(A1,0)) =DAY(DATE(YEAR(A1),MONTH(A1)+1,0)) =TEXT(DATE(YEAR(A1),MONTH(A1)+1,0),"dd") =text(EOMONTH(A1,0),"dd")
28楼传递	=DAY(EOMONTH(A2,0))
29楼果果8706	=DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0))
30楼 keven	=DATE(YEAR(I48),MONTH(I48)+1,0)-DATE(YEAR(I48),MONTH(I48),0)
31楼 keven	=EOMONTH(I48,0)-EOMONTH(I48,-1) 这个公式目测更简单！
32楼 manageadmi	=DAY(EOMONTH(A2,0)) 无标题.jpg
33楼竽駐鈊甜	=DAY(DATE(YEAR(C1),MONTH(C1)+1,0))
34楼再见亦难	=EOMONTH(A1,0)-EOMONTH(A1,-1)
35楼 LOGO	=DAY(EOMONTH(A2,0))
36楼 slg36	=DAY(DATE(YEAR(A2),MONTH(A2)+1,0)) =DAY(DATE(YEAR(A2),MONTH(A2)+1,1)-1) =DAY(EOMONTH(A2,0)) =EDATE(A2,1)-A2 后两个公式在2003版中加载分析工具库
37楼 yjkuocangv	=DAY(EOMONTH(A1,0))
38楼 sichen0504	=RIGHT(DAY(DATE(YEAR(G2),MONTH(G2)+1,0)),2)
39楼 Gengxin1218	=DATE(YEAR(A2),MONTH(A2)+1,1)-DATE(YEAR(A2),MONTH(A2),1)
40楼 katsuge	=DAY(EOMONTH(I2,0)) =DAY(EDATE(a2,1)-1) =DAY(DATE(YEAR(a2),MONTH(a2),1)-1)
41楼 gouweicao78	常规的： =DAY(EOMONTH(A2,0)) =DAY(DATE(YEAR(A2),MONTH(A2)+1,0))

【练习题003】根据指定日期返回所在日期天数_已开贴