假设单元格A1中是任意日期
上月有多少天?
=DAY(DATE(YEAR(A1),MONTH(A1),0)) =DAY(EOMONTH(A1,-1)) =DAY(A1-DAY(A1)) =A1-EDATE(A1,-1)
![](http://image83.360doc.com/DownloadImg/2015/03/1022/51005701_1)
本月有多少天?
=DAY(DATE(YEAR(A1),MONTH(A1)+1,0)) =DAY(EOMONTH(A1,0)))
![](http://image83.360doc.com/DownloadImg/2015/03/1022/51005701_2)
下月有多少天?
=DAY(DATE(YEAR(A1),MONTH(A1)+2,0)) =DAY(EOMONTH(A1,1))
![](http://image83.360doc.com/DownloadImg/2015/03/1022/51005701_3)
书也买了一大堆,没心思看。教程也下载了好多,越看越迷糊。excel到底该怎么学?其实,通过视频学习才是最好的学习途径,点左下角'阅读原文' 查看兰色幻想+小妖录制的超全的290集excel视频教程。
|